Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load measures from Excel in QlikSense

Hi All,

Currently i am loading all variables successfully from an excel file into Qlikview via below script. Is there any way to load the same variables into QlikSense measures from the same excel file having dimensions as MeasureName, MeasureExpression, Description, Tags.

Concatenate LOAD Variable,

Expression as vExpression

FROM

(ooxml, embedded labels, table is PLDynCYPY);

Let vNoOfRows = NoOfRows('Expressions');

For vI = 0 to (vNoOfRows - 1)

Let vName_Variable = Peek('Variable',vI,'Expressions');

Let [$(vName_Variable)] = Peek('vExpression',vI,'Expressions');

Next

Thanks

SAK

0 Replies