topic Pivot table total caluculation in QlikView

Pivot table total caluculation

Anonymous — Wed, 10 Dec 2014 11:57:26 GMT

Here in the above pivot table .... i want the Total and the expression for it is ...

Re: Pivot table total caluculation

rubenmarin — Wed, 10 Dec 2014 12:22:57 GMT

Hi, maybe:

=(if(Dimensionality()<2,

[Coperate SLP]*Performance

))

Re: Pivot table total caluculation

Anonymous — Wed, 10 Dec 2014 12:52:13 GMT

hey i tried but its not coming as a sum .... is there any way to do it done.

Re: Pivot table total caluculation

rubenmarin — Wed, 10 Dec 2014 12:56:14 GMT

Wich result that returns? With a sample I can give more help, anyway you can try:

=(if(Dimensionality()<2,

Column(5)*Column(6)

))

Re: Pivot table total caluculation

Wed, 10 Dec 2014 12:59:58 GMT

Hi, give the below a try

=if(Dimensionality()<=1,

[Coperate SLP]*Performance

)

hope that helps

Joe

Re: Pivot table total caluculation

Anonymous — Wed, 10 Dec 2014 13:12:30 GMT

nope the total is not correct joe.. help me .

Re: Pivot table total caluculation

Anonymous — Wed, 10 Dec 2014 13:15:07 GMT

thats like the results are help me ruben .... thanks

Re: Pivot table total caluculation

Anonymous — Wed, 10 Dec 2014 13:57:43 GMT

can u give me u r mail id?? so that i can explain the query clearly for u

Re: Pivot table total caluculation

linusblomberg — Wed, 10 Dec 2014 14:33:26 GMT

We need more information from you but basically if I understand you correctly [Coperate SLP] is the column. You can't use that in your total since it weighs differently on every row. What is 5% + 10%? that depends on the associated weight right? 5% of 100 or 10% of 10. I'm having difficulties explaining this in words but you can't base your calculation on that column for a good reason. What is the expression for that column?

Re: Pivot table total caluculation

Anonymous — Wed, 10 Dec 2014 14:37:13 GMT

hey give me u r mail id . i can send it clearly . or remote me i can show you.

Re: Pivot table total caluculation

linusblomberg — Wed, 10 Dec 2014 15:33:32 GMT

This forum still seem to have issues after the maintenance and I can't go to your profile. But it doesn't matter. Can you make the correct expression in a textbox?

All I'm saying is that I don't think you can use the approach you're using. You can't reference a column when you want %-totals. Either I would try to use dimensionality() with the expression of the column and include the total (sum(total expression)) but I'm not sure this will work. You can also aggregate the values in the loadscript.

good luck

Re: Pivot table total caluculation

Anonymous — Thu, 11 Dec 2014 03:34:13 GMT

hi Linus,

give me u r mail id i can send u expressions.