topic Re: Variables are not working in pivot table in QlikView

Variables are not working in pivot table

Wed, 20 Aug 2014 12:14:36 GMT

I have created a set of expressions in variables which I load from an Excel file. I then loop through the stored variables in the Excel file to load them in my document.

When I use the variable in the table for calculation, the value is not being aggregated properly. I have the same value as the total for all values. This is incorrect.

Consider the following scenario

I have created a variable: vSUMSALES. This has the calculation: SUM(SALES)

I am now using the vSUMSALES variable in another variable: vDaysSales. This has the calculation: SUM(SALES) /SUM(DAYS). This would be alternatively coded to $(vSUMSALES) / SUM(DAYS).

I have a table with 10 unique branch numbers and for each I want to calculate the Day Sales.

When I use the expression in a pivot table it works fine giving an individual Day Sales for each branch. When I use the expression I get the same figure in the Day Sales value.

What am I doing wrong?

Thanks

Re: Variables are not working in pivot table

Gysbert_Wassenaar — Wed, 20 Aug 2014 12:23:23 GMT

No idea, why don't you post the document so we can see what you're actually doing in it. See this document for how to to do that: Preparing examples for Upload - Reduction and Data Scrambling

Re: Variables are not working in pivot table

marthacano01 — Wed, 20 Aug 2014 15:32:47 GMT

Hi RAjesh.

Try this:

I attached an example to explain it better.

The difference is the equal sign in the variable. You need to quit the equal sign if you will use your variable in the report.