topic Re: Forecast sales values computation using average sales price (set analysis) in QlikView

Forecast sales values computation using average sales price (set analysis)

agaetisproject — Fri, 11 Sep 2015 11:55:18 GMT

Hi all,

I am trying to compute a sales amount forecast based on the number of units forecast and the average sales price of a unit.

I struggle with a set analysis statement that is intended to calculate the average sales price of each unit and for each country.

Below is my table:

Th expression for the average price is (intended to get the average price per unit, regardless of the year).

avg({$<Year = {*}>} Value/Unit sold)

My issue is that the yellow cells stick to 0 in my table whereas I would like see in there the average price based on years where there was sales.

Can anyone help me get this statement correct?

Thanks!

MK_QSL — Fri, 11 Sep 2015 12:01:28 GMT

Last Country is A? How you get 30 Average Price for it?

agaetisproject — Fri, 11 Sep 2015 12:10:02 GMT

nope Manish, last country is B, sorry for the typo.

MK_QSL — Fri, 11 Sep 2015 12:39:20 GMT

You can get average price as below

SUM(TOTAL <Country> Value)/SUM(TOTAL <Country> [Unit sold])

now multiply it with your Forecast Units to get the Forecast Value