Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

doespirito
New Contributor III

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

Re: Bad result of an expression in a pivot table

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

Capture.PNG

4 Replies

Re: Bad result of an expression in a pivot table

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

Capture.PNG

Re: Bad result of an expression in a pivot table

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
New Contributor III

Re: Bad result of an expression in a pivot table

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.

Re: Bad result of an expression in a pivot table

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

Community Browser