Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
May I know what are benefits to store QlikView expressions in variables.
We are planning to create the external file to hold expressions in QlikView ad use those variables in the application.
it would be great if you could share the example for this.
Thanks
start writing the expression in qlikview script variable and store the script as qvs.
you can then use this script in number of application. Some link below for your help...
https://www.quickintelligence.co.uk/qlikview-include-files/
https://community.qlik.com/t5/QlikView-Scripting/how-can-I-open-a-QVS-File/td-p/367093
Hello @kishorj1982,
Storing expressions in variables will help you to use the same expression at multiple locations without writing it. Instead, just put your variable at the place where you want to apply your expression
So, when you know you have long-expression to create for some analysis and that expression is going to be used at multiple places, just create Variable and it will replace with your expression.
For more information: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/work-with-vari...
Hope it will solve your query. If it does, mark the answer as a solution, so that others can understand it too.
Regards,
Rushika
Hi,
Storing expressions in variable is good practice. Lets assume. you are using same expression in multiple charts then the variable you can use instead of expression everywhere, this will save your time as well as easy to maintain in future if logic needs to change.
If its in external file then even you dont need to open the QVW file to modify the logic of the expression , you can modify externally without opening application.