Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table Total issue with expression

pivot performance total.PNG.png

Here in this pivot table i m having the issue with the Performance Total it is varying .

It should be Sum([Coperate SLP])*[Performance])

Means (103*106)+(0*111)=109.18 but its displaying as 111 that is the problem over here.

Please Help me guys since a week i m striving to get it done but its not getting perfect.

14 Replies
prieper
Master II
Master II

Suggest to include the fields, which you wish to factorize one-by-one into the chart and verify, that the values are really as you expect.

HTH Peter

Anonymous
Not applicable
Author

hi peter ,

i m trying since a week and its annoying for me can u remote me and

help .if possible for u means.

On Mon, Dec 8, 2014 at 8:12 PM, Peter Rieper <qcwebmaster@qlikview.com>

Anonymous
Not applicable
Author

hi peter ,

     i m trying since a week and its annoying for me can u remote me and help .if possible for u means.

prieper
Master II
Master II

please attach an sample-file with your problem

Peter

Anonymous
Not applicable
Author

actually its a huge app and expressions can u take remote its easy .

On Mon, Dec 8, 2014 at 8:24 PM, Peter Rieper <qcwebmaster@qlikview.com>

Anonymous
Not applicable
Author

how does the expression for column "Performance" and "Corporate SLP" looks like?

Anonymous
Not applicable
Author

i will send u all the expressions as text please check ....

On Mon, Dec 8, 2014 at 8:31 PM, Rudolf Linder <qcwebmaster@qlikview.com>

Anonymous
Not applicable
Author

hi rudolf ,

Can u share me u r mail id please.

ashwanin
Specialist
Specialist

Hi Bunny,

To check it you must have to add the sample qvw.