topic Re: Last 12 Months in QlikView

Last 12 Months

Wed, 26 Oct 2016 16:40:39 GMT

hello ,

I managed to set up the set analysis expression that generates the sum of the rolling 12-month from MAX the month loaded data.

But the problem is that by selecting one/many month (MMMYYYY) of the selection list, it takes maximum months slected as the reference !!

Set analysis expression is :

=sum({<[MARQUE]={'BMW'},YYYY= ,MMM= ,MMMYYYY=,[MMMYYYY]={'>=$(=AddMonths(max([MMMYYYY]),-11))'}>

+<[PW]={'286'},YYYY= ,MMM= ,MMMYYYY= ,[MMMYYYY]={'>=$(=AddMonths(max([MMMYYYY]),-11))'}> Sales)

thanks .

sunny_talwar — Wed, 26 Oct 2016 16:49:50 GMT

Try this:

=Sum({<[MARQUE]={'BMW'},YYYY= ,MMM= ,MMMYYYY=,[MMMYYYY]={'>=$(=AddMonths(Max({1}[MMMYYYY]),-11))'}>

+<[PW]={'286'},YYYY= ,MMM= ,MMMYYYY= ,[MMMYYYY]={'>=$(=AddMonths(Max({1}[MMMYYYY]),-11))'}>Sales)

Fri, 28 Oct 2016 09:27:07 GMT

Thanks Sunny . It works