Load expressions from Excel and use in chart

[vikasmahajan]

Dear All,

I have excel sheet with expressions I want to load multiple expressions from excel in qlikview and use this expression multiple

charts it is giving error.

Please guide me how to use the same

Thanks

Vikas

[fvelascog72]

Try this:

for i = 0 to NoOfRows('Exp_Test')-1

let vName   = peek('Exp_Name', i, 'Exp_Test');   // Name of the variable

let vNumber = peek('ExpID', i, 'Exp_Test'); // Number of the variable

next i

let i = null();

let vName = null();

[vikasmahajan]

after reload how to use the same in chart ?

Vikas

[satishkurra]

Let's say your expression is Sum(Sales) in your excel and give some label as Sales $ and your variable name in chart expression should contain $(Sales)

Thanks

Example:

In excel file:

SET Sales=Sum(Sales)

In chart expressions, the label can be Sales $ and expression is $(Sales). That means $(variablename)

[vikasmahajan]

Your Script worked for me , Now I want to store all id with expressions and use in chart using $.

Vikas

[satishkurra]

2 Approcahes

1. Use a for loop for all your ID's and call them in EDIT Script

2. Simple way is create all your expressions in notepad file as below

SET Sales=Sum(Sales);

SET Sales1=Avg(Sales);

SET Sales2=Min(Sales);

Put all the above statements in notepad file and create an include statement and in your chart expressions use

$(Sales),$(Sales1) and $(Sales2)

Thanks

Satish