Now a few other things to keep in mind about FirstSortedValue. In this case we would like to see which Employee was the first one to contact a customer, so we need to do a GROUP BY to aggregate the data at the right level. The TimeStamp is the sort-weight we would like to evaluate the EmployeeID by.Īs FirstSortedValue() is an aggregation function, we need to specify which column(s) to group the result by. Reviewing our script we see that EmployeeID is the value we would like to have returned. In this case we use timestamp.įirstSortedValue() used the following syntax: FirstSortedValue ( value, sort-weight ) The nice thing of using FirstSortedValue() is that we can precisely determine the sort-weight, or sort order, we would like to use. Using FirstSortedValue() we can retrieve the first employee in one quick load: Having analyzed the question, let’s do some analyzing of the correct answer 😉 We could achieve the same result with Min(), but it would require a more complex script. This leads us to pick the simplest solution, which is answer D, FirstSortedValue(). So we have the requirement of getting the first EmployeeID per CustomerID, without any further explicitly stated requirements. Therefore, in this case, the simplest solution will be the best. Looking at the possible answers, there are no mentions of any temporary tables or joins, only the script functions are provided.Looking at the table provided there are a few possibilities to find out who the first employee was, namely the TimeStamp or the Appointment Type.As a general rule, anything that can be fixed in the script should be fixed in the script, so our first assumption will be that it needs to be fixed within the script. The request is to retrieve the first employee that had contact with the customer. To understand this let’s examine the question a bit closer and interpret what the examiner might want to hear. In the case of this question the correct answer is FirstSortedValue(). Qlik certication exam questions often contain some ambiguity, and as we’re striving for realism here, we include this in our questions as well. Understanding the question and understanding what answer the examiner wants to hear on a certification exam are sometimes two different things. The correct answer is D: FirstSortedValue() Last Friday we asked the following Qlik Data Architect certification practice question: Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page.
0 kommentar(er)
