topic Re: Set Analysis in QlikView

Set Analysis

Mon, 19 Sep 2016 09:10:00 GMT

Hi All,

I am getting not getting a desired result withe below expression

=Sum({<MonthName={"=$(=Date(AddMonths(MonthName,-1),'MMMYY'))"}>} SALES)

It shows an 0 sales which is not true .

I want to sum the sales for the previous month, here MonthName is the current month .

Can anyone please help ?

Thanks

Shivaj

Anonymous — Mon, 19 Sep 2016 15:38:42 GMT

try this

Sum({<MonthName={"=$(=Date(AddMonths(max(MonthName),-1),'MMMYY'))"}>} SALES)

Also check your 'Monthname' format

stigchel — Mon, 19 Sep 2016 15:54:55 GMT

Try with

=Sum({<MonthName={'$(=Date(AddMonths(MonthName,-1),'MMMYY'))'}>} SALES)

Mon, 19 Sep 2016 18:21:12 GMT

Thanks it works