Hello,
Is it possible create a load script to systematically create a list of Master Items -> Measures within Qlik Sense?
Currently I use the load script to load a list of variables. For this I use the following script, which works in both QlikView and Qlik Sense.
I would love to take advantage of the master items in a similar fashion, including a description and tags where needed.
Script used to load variables. (input spreadsheet containing 2 columns (Variable, Expression)
Cheers,
Stu
Variables:
LOAD Variable,
Expression
FROM
[..\Data\Variables.xlsx]
(ooxml, embedded labels);
Let vNoOfRows=NoOfRows('Variables');
For vCount=0 to ($(vNoOfRows)-1);
Let vVar=Peek('Variable',vCount,'Variables');
Let [$(vVar)]=Peek('Expression',vCount,'Variables');
Next
Drop table Variables;