topic Re: wrong result in pivot table in QlikView

wrong result in pivot table

doespirito — Thu, 06 Sep 2018 08:48:17 GMT

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

Re: wrong result in pivot table

andrey_krylov — Thu, 06 Sep 2018 08:59:41 GMT

Hi, try to aggrigate your expression

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

Re: wrong result in pivot table

manoranjan_d — Thu, 06 Sep 2018 09:20:11 GMT

try this

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

Re: wrong result in pivot table

doespirito — Thu, 06 Sep 2018 12:21:58 GMT

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