Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bunnyv123
Creator II
Creator II

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

  ))

bunnyv123
Creator II
Creator II
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

Hi, give the below a try

=if(Dimensionality()<=1,

  [Coperate SLP]*Performance

  )

hope that helps

Joe

bunnyv123
Creator II
Creator II
Author

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

bunnyv123
Creator II
Creator II
Author

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

bunnyv123
Creator II
Creator II
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?

bunnyv123
Creator II
Creator II
Author

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