0 Replies Latest reply: May 30, 2017 6:54 AM by Stuart Ward RSS

    Systematically load measures into master Library

    Stuart Ward

      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;