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: 
doespirito
Creator
Creator

Bad result of an expression in a pivot table

Hello,

Can someby help me ?

image qv.PNG

see attached file.

thank you very much.

Arnault

1 Solution

Accepted Solutions
sunny_talwar

Can you use straight table instead of pivot table and use Sum of Rows under 'Total Mode' on the expressions tab?

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Can you use straight table instead of pivot table and use Sum of Rows under 'Total Mode' on the expressions tab?

Capture.PNG

sunny_talwar

Or use this expression in the pivot table:

Sum(Aggr(Round(((Sum({<Entete2={'RESULTAT NET avant fact nr/cp'}>} REEL)+(Sum({<Entete2={'Total des charges yc Exploitation'}>} REEL)*0.01))/Sum({$<RATIO={'EXPOR','EXPORP'}>} REEL_RAT)),0.001)*Sum({$<RATIO={'EXPOR','EXPORP'}>} REEL_RAT), CC_LIB_ND2))

doespirito
Creator
Creator
Author

ok   Sunny,

just using Sum of Rows under 'Total Mode' works

your expression with Aggr works fine too. But is a little more complicated.


thank you very much.

sunny_talwar

That is why I suggested using a straight table. Aggr() can be used if you have to use a pivot table for some reason