topic Re: Expression variables in pivot table in QlikView

Expression variables in pivot table

Anonymous — Tue, 06 Sep 2011 08:49:13 GMT

Hi, I've replaced hardcoded expressions in a pivot table by variables which are loaded during script run (SET ...). Works well. Except that when I now expand my pivot table from the 1st dim to the 2nd dim, the values for the 2nd dim items are the same (totals). This doesn't happen when I hardcode my expressions. Then I see the different values for both items within the 2nd dim. When I look at the variable values from the menu they are exactly the same as the hardcoded ones. But being handled differently in the pivot table? Any ideas... Thanks, Sander.

Re: Expression variables in pivot table

Anonymous — Wed, 07 Sep 2011 08:22:43 GMT

Hi, added an example. Some advice on syntax in this case or other solution? Regards, Sander

Re: Expression variables in pivot table

lironbaram — Wed, 07 Sep 2011 09:03:36 GMT

hei

attach is your file with what you want

look at the script i changed it a little bit

an also in the pivot table expression

in general when you want a varaible to calulte the formula in the the table the varaible formula need to be aith out "=' sign

when you use '=' sign in varaible the application calculte the varaible on all the data and return a number not a formula

Re: Expression variables in pivot table

Anonymous — Wed, 07 Sep 2011 09:14:03 GMT

Hi, perfect! Thanks again for your help. I'll keep this syntaxing in mind. Regards, Sander