topic Re: how to calculate the average? in QlikView

how to calculate the average?

Sat, 08 Aug 2015 03:53:33 GMT

Hello everyone,

Please help me as I calculate the average of the months from January to March by item

Thanks

ecolomer — Sat, 08 Aug 2015 04:32:55 GMT

try this:

avg({<Month={'ene 2015','feb 2015','mar 2015'}>} Value)

brenner_martina — Sat, 08 Aug 2015 12:57:35 GMT

Hi,

another way is to build the sum and devide through Count(Months)

Sum(Value)/Count(Distinct Month)

Greetings from EVACO GmbH, Munich

Martina

Sat, 08 Aug 2015 14:29:32 GMT

Thank you very much for your help,

But, consider as zeros in average?

Thanks,

brenner_martina — Sat, 08 Aug 2015 14:37:32 GMT

Hello,

the question is, if you want to get 0 or NULL in your formulas. p.e. you can enter the following formulas for every month:

If(Sum(Value)=0,Null(),Sum(Value))

than you can work with Count(Distinct Month)

Greetings from EVACO GmbH, Munich

Martina

Sat, 08 Aug 2015 15:26:30 GMT

Hi Martina,

I enter the formula for every month, but not averaged zeros

Thank you for your help