Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Systematically load measures into master Library

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;