Discussion board where members can learn more about Qlik Sense App Development and Usage.
The Master Item feature in Qlik Sense allows you to define complex expressions (including Set Analysis calculations for instance) as reusable measures for the end-users.
Currently, the Master Items are defined at application level, and hence, can be shared within the application.
What would be the best way to share these master item definitions between different applications ?
There is no native way to do this in Qlik Sense yet,
However have recently created a tool that helps you do this by saving Master Items in an excel file. If you're interested check out our Master Item Manager extension on Qlik Branch.
You gave an example on how to create a variable from a dimension.
How would you load all rows of the Excel file at the same time? (and not just 'Regions')
Thanks for your help.
You can use qdevops command from https://github.com/rogerio-faria/qdevops
So you can schedule these commands. Example:
1 - Export the master measures to a file
qdevops -u=node1.txt -m=export,xxxx-x-x-xxx-xxxxx-xx,metrics.txt
2 - Once, measures are stores in vars.txt, just import to the other app (may be other server), you can use a .bat file
qdevops -u=node1.txt -m=import,yyyy-y--yyyy-yyyyyy,metrics.txt
qdevops -u=node2.txt -m=import,2222-22222-222-2222,metrics.txt
qdevops -u=node2.txt -m=import,3333-3333-3333-3333,metrics.txt
I currently have 150 Master Items of KPI's which have similar but slightly different set analysis per region. A simple find/replace would allow me to updates them as needs change within minutes; however, I'm currently doing this manually in 5+ hours. I'm happy to find this post and wonder if I export the Master Items, modify the file with find/replace, can I import them back into the same application and overwrite the existing Master Items for my purpose?