topic wrong values after changing the level of analysis in QlikView

wrong values after changing the level of analysis

Tue, 09 Apr 2013 15:51:52 GMT

Hi experts,

I try to calculate the average, absolute value of the difference between 'average value' and 'value per month'. Works well with

fabs(

(avg(total <MATNR> consumption)-

sum(total <MATNR, year, month> consumption)))

/count(DISTINCT month)

as long as i stay at the same level.

So far so good, but for my application i need to have a look at the higher levels as well. The problem is that i don't get the right values after hiding column "month" in the pivot table i work in.

example is attached

Thanks in advance and best regards

Sebastian

Re: wrong values after changing the level of analysis

Gysbert_Wassenaar — Wed, 10 Apr 2013 12:15:07 GMT

Try:

avg(aggr(fabs(

(avg(total <MATNR> Verbrauch)-

sum(total <MATNR, GJAHR, Monat> Verbrauch)))/count(DISTINCT Monat),MATNR,GJAHR,Monat))

See attached qvw

Re: wrong values after changing the level of analysis

Wed, 10 Apr 2013 16:16:09 GMT

Hello Gysbert,

that's awesome!

thanks a lot and best regards

Sebastian