8 June 2022 The difference between SET and LET in Qlik 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 the difference between the SET and LET statements in Qlik Sense: The correct answer is A: vLoadStart contains the date and time that the script started, vLoadEnd contains the value “Now()” Even without having edited a single letter in the Qlik script there are already SET statements to be found. Always included you will find the Main script page with a row of default settings all starting with SET. Now concerning last weeks question and answer we can be pretty clear: SET variablename = string LET variablename = expression By using SET Qlik will store the variable as the string provided, using LET will evaluate the string as an expression. Or to put it more simply: SET vString = 1+1; Will return vString = 1+1. LET vString = 1+1; Will return vString = 2. Returning to last week’s question: LET vLoadStart = Now(); Will return vLoadStart = the result of the expression now(), which is the current time of the system clock. SET vLoadEnd = Now(); Will return the string ‘Now()’. One of the main things to consider while using this is the end result and how to use it in the front end. Lets have a look at the following example: We would like to have a text object within the app in which the users can see when the load started and when it ended using the following expression: ‘Start Reload: ‘ & vLoadStart & CHR(10) & ‘End Reload: ‘ & vLoadEnd The end result will look as expected: However, if we change the variable vLoadEnd to use Dollar Sign expansion: ‘Start Reload: ‘ & vLoadStart & CHR(10) & ‘End Reload: ‘ & $(vLoadEnd) It will evaluate the text within the expansion, being Now(), which results in: While it looks better, it is definitely not correct! It is displaying the time at which Now() is evaluated (which is at the moment of calculating the Text Object) and not the time when LET has evaluated the expression within the script. The same goes for if we use the Dollar Sign expansion on vLoadStart. That will make $(vLoadStart) evaluate 08-06-2022 17:06:52, which returns a Null value, because it will start calculating 8 minus 6 minus 2022 and then run into trouble with the space and the colon, since they are not interpreted as correct symbols for calculations by Qlik. So it is worth remembering that using LET can already perform expressions in the script and using the Dollar Sign expansion might not give the exact results as expected at first hand. That’s it for this week. See you next Friday? Take your Qlik skills to the next level! If you enjoy Qlik, you’ll love the Masters Summit for Qlik. 3 days of Qlik deep dives, peer networking, ready to use resources and much more! See you there! Test your Qlik knowledge! Check out the Friday Qlik Test Prep archive for more Qlik questions and answers. Friday Qlik Test Prep Script Solution How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 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 6 September 2023 Battle Ships & Big Data: join us for some fun! Unleash the Power of Data in the Ultimate Battle Ship Game! Join us at the Big Data Expo for a thrilling experience that blends strategy, competition, and analytics. Discover how data influences gameplay and be part of our research! Plus, dive into the world of data and analytics with the experts from Bitmetric. Don’t miss out! See you at booth 46! Bitmetric Event Qlik Team 29 August 2023 Qlik Sense Enterprise for Windows – Critical Security Fixes Two security issues in Qlik Sense Enterprise for Windows have been identified and patches made available. Details can be found in Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-41266, CVE-2023-41265). New Release Qlik Security
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
6 September 2023 Battle Ships & Big Data: join us for some fun! Unleash the Power of Data in the Ultimate Battle Ship Game! Join us at the Big Data Expo for a thrilling experience that blends strategy, competition, and analytics. Discover how data influences gameplay and be part of our research! Plus, dive into the world of data and analytics with the experts from Bitmetric. Don’t miss out! See you at booth 46! Bitmetric Event Qlik Team
29 August 2023 Qlik Sense Enterprise for Windows – Critical Security Fixes Two security issues in Qlik Sense Enterprise for Windows have been identified and patches made available. Details can be found in Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-41266, CVE-2023-41265). New Release Qlik Security