topic Re: wrong results on a straight table in QlikView

wrong results on a straight table

doespirito — Mon, 03 Apr 2017 16:32:58 GMT

Hello,

Could every-body help me to know (see attached file) whitch mistake i make in this straight table.

One élément of a dimension desappears in the average amount.

thank you very much.

Best regards,

Arnault

Re: wrong results on a straight table

aarkay29 — Mon, 03 Apr 2017 16:44:21 GMT

PFA

Just use the expression total instead of sum of rows.

Re: wrong results on a straight table

doespirito — Mon, 03 Apr 2017 16:49:15 GMT

ok thank you,

but one element (37261 whitch is 192 in november) , has desappeared in the straight table.

do you know why ?

Re: wrong results on a straight table

sunny_talwar — Mon, 03 Apr 2017 16:51:16 GMT

May be this:

round((Sum({$<MOIS={"<=$(=max(MOIS))"},[CANALCOM]={'OUI'}>} (VENTEOJD)) / max(TOTAL MOIS)))

Re: wrong results on a straight table

doespirito — Mon, 03 Apr 2017 16:55:22 GMT

yes it is perfect.

just a question : why do i have to add TOTAL here ?

thank you very much

Re: wrong results on a straight table

aarkay29 — Mon, 03 Apr 2017 17:29:43 GMT

your expression max(MOIS) returns null for the ID 37261 since it has value in the mois of 11 therefore the 37261 returns'-' and automatically suppressed

you need to to use max(total MOIS) to return 12 or if you want to return 11 which is max(mois) for value 37261 use this exp Max({$<MOIS={"<=$(=max(MOIS))"},[CANALCOM]={'OUI'}>}MOIS)

since you need avg for 12 months max(total MOIS) will be your expression

Hope it helps

Re: wrong results on a straight table

sunny_talwar — Mon, 03 Apr 2017 17:30:38 GMT

Max(MOIS) for 37261 was somehow showing as null... changed it to Max(TOTAL MOIS) which calculate Max MOIS across all the INSEE

Re: wrong results on a straight table

doespirito — Tue, 04 Apr 2017 07:34:18 GMT

Aar, Sunny,

Your answers are very clear.

Thank you very much.

Arnault