31 August 2022 How to reuse script in Qlik Sense 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 reusing script in Qlik Sense. The correct answer is C: On the server, store the script as a QVS file Given the fact that in bigger environments you will probably have to work with multiple developers or in bigger teams it is wise to have certain parts of the script readily available for reuse. By doing this, certain scripting logic and definitions are defined in a fixed place and thus possible to be reused everywhere. This is done by adding these parts of the script to a .QVS file and including them in the script by using include or must_include. Reusing script in Qlik Sense, an example Lets take the script below as an example. In here we define the various stages of publishing of the app based on a prefix given to the filename. For example [DEV] Sales Dashboard. This tells us that the Sales Dashboard is currently in the development phase. The script below defines based on this prefix that the variable vDTPFolder should be dev. This is used to determine the load location of the QVD files. It is not uncommon for development and testing data to be different datasets then the final production dataset. So in this case ‘[DEV] Sales Dashboard’ will load from: [lib://$(vDTPFolder)/Facts.QVD]. IF MATCH(LOWER(TEXTBETWEEN(DocumentTitle(),'[', ']', 1)), 'tst') THENLET vDTPFolder = 'tst';ELSEIFMATCH(LOWER(TEXTBETWEEN(DocumentTitle(),'[', ']', 1)), 'dev') THENLET vDTPFolder = 'dev';ELSELET vDTPFolder = 'prd';ENDIF; Since this DTP cycle will be used everywhere in the corporation’s environment, we want to use this script in every single application. Instead of answer A and mailing this script to all developers, it is a far better and more sustainable solution to store this on a server. This keeps maintainability to a minimum, since if changes occur, it is manageable from a single location. Also all newcomers can easily add this to their applications or understand what is happening. Storing Qlik script externally The script above needs to be stored before we can use it. This can be done by storing it as a .QVS file. QVS stands for QlikView Script and indeed comes from QlikView. In QlikView it was possible to export a whole script page at once to a QVS file. Under the file option you select ‘export to Export to Script file’ and this creates a QVS. While Qlik Sense is able to use QVS files, it is no longer possible to export them in the same manner. When using Qlik Sense you simply copy and paste the script you wish to reuse into a text file and store it. You can store this under .QVS or .TXT, since both will work. Including the script To include the script, we need to add it to the script in the data load editor. This is done by using include or must_include. The difference in both being, that must_include will give an error if the file cannot be found, while include fails silently. The syntax is as following: $(Include=filename) $(Must_Include=filename) So if we store the example above as DTPInclude.QVS and wish to have a notification when the file cannot be found, we use the following line in the script: $(Must_Include=lib://Scripts/DTPInclude.QVS); Please be aware that there may be no spaces between the equal sign, otherwise it will not work. When reloading Qlik will now run the stored script as it was there. That’s it for this week. See you next Friday? More from the Bitmetric team Take your Qlik skills to the next level! Since 2013, the Masters Summit for Qlik is the premier advanced training for Qlik. Join us in Vienna and take your Qlik skills to the next level. Join the team! Enjoying these challenges? We have many more, and we’ll even pay you to solve them 😉 Check out our job opening. Friday Qlik Test Prep Script Solution How can we help? Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have. Call us Mail us 29 March 2024 Dealing with missing and late arriving values with OtherSymbol and other solutions Learn effective strategies for handling missing or late-arriving dimension values in Qlik with our expert guide. Discover how to use OtherSymbol, WHERE NOT EXISTS, and other solutions to deal with early-arriving facts Data Model Friday Qlik Test Prep Qlik Solution 22 March 2024 Picking the right color palette for your visualization Discover how to choose the perfect color palette for your data visualizations with our expert guide. Learn about single, categorical, sequential, and diverging color palettes to enhance your charts and graphs. Ideal for data analysts and visualizers. Friday Qlik Test Prep Qlik SenseTheme Visualization 11 March 2024 5 ways to pass selections between Alternate States in Qlik Sense This guide delves into the intricacies of passing selections between Alternate States in Qlik Sense, offering a comprehensive look at techniques such as explicit and implicit assignments, merging selections, and utilizing granularity. Perfect for developers and data analysts, it equips you with the knowledge to leverage Alternate States effectively, enhancing dashboard functionality and enriching data analysis. Expressions Friday Qlik Test Prep Qlik
29 March 2024 Dealing with missing and late arriving values with OtherSymbol and other solutions Learn effective strategies for handling missing or late-arriving dimension values in Qlik with our expert guide. Discover how to use OtherSymbol, WHERE NOT EXISTS, and other solutions to deal with early-arriving facts Data Model Friday Qlik Test Prep Qlik Solution
22 March 2024 Picking the right color palette for your visualization Discover how to choose the perfect color palette for your data visualizations with our expert guide. Learn about single, categorical, sequential, and diverging color palettes to enhance your charts and graphs. Ideal for data analysts and visualizers. Friday Qlik Test Prep Qlik SenseTheme Visualization
11 March 2024 5 ways to pass selections between Alternate States in Qlik Sense This guide delves into the intricacies of passing selections between Alternate States in Qlik Sense, offering a comprehensive look at techniques such as explicit and implicit assignments, merging selections, and utilizing granularity. Perfect for developers and data analysts, it equips you with the knowledge to leverage Alternate States effectively, enhancing dashboard functionality and enriching data analysis. Expressions Friday Qlik Test Prep Qlik