6 April 2022 Set Analysis: Literal vs Search strings Share this message Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: This is typically a relatively tough question, but fortunately everyone who participated is above average! The correct answer is D You may wonder why this is a tough question, that’s because in the past both single and double quotes would be evaluated as a search expression by Qlik. This has lead to single and double quotes being used interchangeably, while formally only the double quotes are correct. The single quotes (‘) are used to denote a literal value. So by using single quotations in Set Analysis, you are looking for an exact match with that value. In this case the answer B solution will be looking for literally Internal* as field value. By using double quotes (“) Qlik will interpret this as a search value. In this example, the correct answer D, will be conducting a search for Internal*. The asterisk is a wildcard that can match any (sequence of) character(s). In this case Internal-Call, Internal-Chat and Internal-Email would be matched. What about flag fields? Yes, if this particular condition is one you want to test more often then it can be beneficial to create flag fields in your data model. This will make your Set Analysis easier and in cases more performant as well. In the context of this question though, we only wanted to test if you knew the difference between single and double quotes in Set Analysis. We’ve already established that you’re all above average 😉 That’s it for this week. See you next Friday? And remember: If you have suggestions for questions, we love to hear from you via WhatsApp or at info@bitmetric.nl If you’re enjoying these questions and want to work on stuff like this every day (but a bit more challenging), we’re always on the lookout for new colleagues. Check our job openings here. Expressions Friday Qlik Test Prep Qlik Set Analysis Solution How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 29 June 2022 LOOKUP Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is C: Roller, UMW, Cobretti, Grotti Most of you have gotten this answer right and that is no surprise. Things like vertical lookup, […] Friday Qlik Test Prep Solution 22 June 2022 GROUP BY Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is D. The problem stated in this question was that the data in the front end showed wrong results. By examining the table in […] Friday Qlik Test Prep Solution 15 June 2022 AGGR Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is C: Avg(Aggr(Sum(NumberOfProducts * ProductPrice), OrderID)) To explain the answer let’s see what it is that is exactly wanted. We have a straight table […] Friday Qlik Test Prep Solution
29 June 2022 LOOKUP Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is C: Roller, UMW, Cobretti, Grotti Most of you have gotten this answer right and that is no surprise. Things like vertical lookup, […] Friday Qlik Test Prep Solution
22 June 2022 GROUP BY Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is D. The problem stated in this question was that the data in the front end showed wrong results. By examining the table in […] Friday Qlik Test Prep Solution
15 June 2022 AGGR Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question: The correct answer is C: Avg(Aggr(Sum(NumberOfProducts * ProductPrice), OrderID)) To explain the answer let’s see what it is that is exactly wanted. We have a straight table […] Friday Qlik Test Prep Solution