topic Re: variable whit calculation in pivot table in QlikView

variable whit calculation in pivot table

ester_pr — Sun, 21 Aug 2011 06:56:46 GMT

Hi I have a very long calculation so i put it in a variable,

If I am puting the variable in the pivot table it gives me the sum of all dimension although the dimension is in the pivot table

what should i do?

Thanks,

Ester

Re: variable whit calculation in pivot table

ToniKautto — Sun, 21 Aug 2011 08:15:51 GMT

In this scenario you need to keep in mind that the variable will be a pre-calculated value if it has an initial equal sign (=). If you instead remove the equal sign your variable becomes a string with the expression as it's content, expanding that will then mean that the actual calculaiton is performed on each row in your table.

Re: variable whit calculation in pivot table

ester_pr — Sun, 21 Aug 2011 08:44:28 GMT

Thanks you have been very halp full,

Ester

Re: variable whit calculation in pivot table

ToniKautto — Sun, 21 Aug 2011 09:32:04 GMT

Good to hear your issue was resolved. Please always mark helpful or correct answers, to make community content more reusable for others.

Re: variable whit calculation in pivot table

ester_pr — Thu, 25 Aug 2011 09:03:11 GMT

Hi Toni,

Can you help me again?

I have made a condision that if i dont have the sum take the avg of the pre q,

in the condision i an writing to ignor the month(COS thar is no line in that month) and take p(q), it works jast fine,

but when i add month dimension it does not work, (it gives me the avg to every month)

do you know what to do?

Thanks

Ester