6 April 2022 Literal values vs search strings in Qlik Set Analysis 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 about search strings in Set Analysis: 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? Mail and Deploy webinar Join our upcoming webinar and learn how Mail & Deploy helps you develop and deliver data-driven, high-impact reports from Qlik Cloud, Qlik Sense and QlikView. Test your Qlik knowledge! Check out the Friday Qlik Test Prep archive for Qlik certification questions and answers. Expressions Friday Qlik Test Prep Set Analysis Solution How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 30 November 2023 Qlik Sense exploited in Cactus ransomware campaign We previously reported on patches for two critical vulnerabilities in Qlik Sense Enterprise for Windows. If you haven’t upgraded already, now is the time to take heed: these vulnerabilities are actively being exploited in the Cactus ransomware campaign. 26 October 2023 TimeXtender Job Scheduling with Qlik Application Automation Unlock the power of Qlik Application Automation to schedule TimeXtender jobs efficiently. Discover automation tips for seamless data workflows. Download the template and boost your productivity today! API Automation Qlik TimeXtender 21 September 2023 Qlik Sense Enterprise for Windows – Critical Security Fix #2 A new security issue in Qlik Sense Enterprise for Windows has been identified. This resolves an incomplete fix for the vulnerability that was reported earlier this month. Patches are available and it is recommended to update your Qlik Sense Enterprise for Windows environment at the earliest possibility. New Release Qlik Security
30 November 2023 Qlik Sense exploited in Cactus ransomware campaign We previously reported on patches for two critical vulnerabilities in Qlik Sense Enterprise for Windows. If you haven’t upgraded already, now is the time to take heed: these vulnerabilities are actively being exploited in the Cactus ransomware campaign.
26 October 2023 TimeXtender Job Scheduling with Qlik Application Automation Unlock the power of Qlik Application Automation to schedule TimeXtender jobs efficiently. Discover automation tips for seamless data workflows. Download the template and boost your productivity today! API Automation Qlik TimeXtender
21 September 2023 Qlik Sense Enterprise for Windows – Critical Security Fix #2 A new security issue in Qlik Sense Enterprise for Windows has been identified. This resolves an incomplete fix for the vulnerability that was reported earlier this month. Patches are available and it is recommended to update your Qlik Sense Enterprise for Windows environment at the earliest possibility. New Release Qlik Security