Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table total caluculation

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

11 Replies
rubenmarin

Hi, maybe:

=(if(Dimensionality()<2,

  [Coperate SLP]*Performance

  ))

Anonymous
Not applicable
Author

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

rubenmarin

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

=(if(Dimensionality()<2,

Column(5)*Column(6)

  ))

Not applicable
Author

Hi, give the below a try

=if(Dimensionality()<=1,

  [Coperate SLP]*Performance

  )

hope that helps

Joe

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

linusblomberg
Creator II
Creator II

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?

Anonymous
Not applicable
Author

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