topic Re: average in set analysis in QlikView

average in set analysis

Anonymous — Wed, 14 Oct 2015 10:03:55 GMT

Hello Everyone

My instruction work correctly for each row but when you select some values in chart, it doesn't calculate correct avrage.

if(IsNull(RecieveMonth) ,Avg('42280'- SendMonth ), Avg(RecieveMonth-SendMonth))

i would much appreciate if any body here could helpme

swuehl — Wed, 14 Oct 2015 11:31:51 GMT

That's hard to answer without knowing any details. Could you post a small sample QVW?

You can also try to embed the if() into the aggregation function:

Avg(if(IsNull(RecieveMonth) ,42280, RecieveMonth)) - SendMonth )

Anonymous — Wed, 14 Oct 2015 11:32:15 GMT

Hi,

What does your 'SendMonth' and 'RecieveMonth' contains and which format?