topic Re: AGGR Problem with Previous month MTD in QlikView

AGGR Problem with Previous month MTD

Wed, 10 Sep 2014 07:33:02 GMT

Facing problem in AGGR

I have to calculate Average for sum of previous month (MTD)

and in my scenario I have to write aggr as i cannot directly calculate avg ie i have to do (avg(aggr (sum(),Date,A,B))).

when i Select Calender month the expression is showing null value.

Please Help?

PFA for reference to understand my problem .

Re: AGGR Problem with Previous month MTD

Gysbert_Wassenaar — Wed, 10 Sep 2014 08:05:09 GMT

You'll need to override the selection in calMonth in the set analysis expression. Try: avg({<calMonth=>}aggr(sum({<calMonth=, Date={">=$(=addmonths(monthstart(max(Date)),-1))<=$(=addmonths(max(Date),-1))"}>}Sale),Date))

Re: AGGR Problem with Previous month MTD

Tue, 02 Dec 2014 08:36:47 GMT

Hi Gysbert,

I am facing the same problem. Can you please help me for calculating the average the RunTime for each Job in previous month. Can you please go to the below link.

Aggr() with set analysis