topic Re: Calculation average in QlikView

Calculation average

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I want to calculate the average of each product taking an account the number of periods that differs from a product to another.

you can notice in the attachment that for the product "ADVANCE" there is only five periods available so the average will be the sum of Actual Sales divided by 5 and for the product ANATEO i have to devide the sum of actual sales by 15 because we have 15 periods.

How can I do that?

Thank you,

Alâa Eddine

Re: Calculation average

ogautier62 — Fri, 29 Jun 2018 09:12:43 GMT

Hi,

if you use avg(Sales) as expression you'll have the correct result for subtotal Product

regards

Re: Calculation average

Anonymous — Fri, 29 Jun 2018 09:30:24 GMT

Hello,

thank you for your answer.

I tried that but it does not work correctly.

I show you what i have:

For the product "ADAVNCE", for example if we do the sum we will find 9 products in total on 5 periods so the average will be 9/5.

This is what i want to calculate.

Re: Calculation average

dapostolopoylos — Fri, 29 Jun 2018 10:26:29 GMT

Can you provide a sample document so we can play around with it,in order to find a solution?

Re: Calculation average

sasikanth — Fri, 29 Jun 2018 10:55:59 GMT

Try below exp,

Sum(ActualSales)/Count(Year Month)

Re: Calculation average

Anonymous — Fri, 29 Jun 2018 11:36:59 GMT

Hello,

i tried but the calculation was incorrect.

Any other ideas, please?