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

wrong result in pivot table

Hi,

can anyone explain to me why this simple formula in a pivot table is not correct?


sum(ETC)/count({< VERSION={'REEL'}>} distinct MOIS_PAIE)


Thank you very much


Arnault

Capture.PNG

3 Replies
andrey_krylov
Specialist
Specialist

Hi, try to aggrigate your expression

Sum(Aggr(sum(ETC)/count({< VERSION={'REEL'}>} distinct MOIS_PAIE), Yourdimensions))

manoranjan_d
Specialist
Specialist

try this

sum(ETC)/count(total{< VERSION={'REEL'}>} distinct MOIS_PAIE)

doespirito
Creator
Creator
Author

You put me both on the right track because from 2011 to 2017, I have to divide by 12. It's only in 2018 that we have to divide by the number of months of presence.

I finally put


if (YEAR_PAIE = '2018', sum (ETC) / count ({<VERSION = {'REEL'}>} distinct MOIS_PAIE), sum (ETC) / 12)

Thank you for your help,

Arnault