Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
By the way, in Qlik Cloud, there's also a way to create a central script - a script that you can use to add to several apps without having to write the same script to add the same variables into multiple apps.
Here's how that's done:
Step 01.
Go to the Create section and select the Script option.
Step 02.
Enter name and description for the script.
Step 03.
Click the Create button.
Step 04.
Go to the Editor tab to create the central script.
Step 05.
Write the central script.
Step 06.
Open an app that will need to use this script and in the Data load editor, click the Include Script button.
Step 07.
Select the script that you would like to use and click the Next button.
Step 08.
On the script preview screen, click the Insert button to insert centrally managed script.
That's all. Once the centrally managed script is added, it will look like this:
This way, if you'll ever need to change the script, you can change it in one location and it will update in all of the apps that use it.
This will not only centralize your expressions but also centralize the script that loads those expressions.
Central scripts can be created and used in an on-prem Qlik Sense as well, but the way to create and add a central script is different.
Loading expressions from a spreadsheet and storing them in variables is how I tend to centralize expressions as well.
If you're looking for an example of what that would look like, here's the script for it:
// load spreadsheet containing variable names and expressions
centralExpressions:
LOAD
Variable,
Expression
FROM [lib://howdash:DataFiles/centralExpressions.xlsx]
(ooxml, embedded labels, table is Sheet1)
;
// loop through each row in spreadsheet and create a variable with corresponding expression
For i = 0 to NoOfRows('centralExpressions') - 1
Let vVariableName = Peek('Variable', $(i), 'centralExpressions');
Let vExpression = Peek('Expression', $(i), 'centralExpressions');
Let $(vVariableName) = '$(vExpression)';
Next i
// cleanup
Let vVariableName = Null();
Let vExpression = Null();
Let i = Null();
Drop Table centralExpressions;
This will load data from a spreadsheet which look like this:
and create a variable for each row in the spreadsheet. The variables will then appear in whichever app that you add this script to. In the app the variables will look like this:
You can then, as Oleg suggested, write expressions that use these variables like this:
By the way, in Qlik Cloud, there's also a way to create a central script - a script that you can use to add to several apps without having to write the same script to add the same variables into multiple apps.
Here's how that's done:
Step 01.
Go to the Create section and select the Script option.
Step 02.
Enter name and description for the script.
Step 03.
Click the Create button.
Step 04.
Go to the Editor tab to create the central script.
Step 05.
Write the central script.
Step 06.
Open an app that will need to use this script and in the Data load editor, click the Include Script button.
Step 07.
Select the script that you would like to use and click the Next button.
Step 08.
On the script preview screen, click the Insert button to insert centrally managed script.
That's all. Once the centrally managed script is added, it will look like this:
This way, if you'll ever need to change the script, you can change it in one location and it will update in all of the apps that use it.
This will not only centralize your expressions but also centralize the script that loads those expressions.
Central scripts can be created and used in an on-prem Qlik Sense as well, but the way to create and add a central script is different.
