Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.