Issue With previous month set analysis expression

svsudhakar — Mon, 28 Jul 2014 08:56:54 GMT

Hi ,

I have written one SET Expression to get the last month values. But this expression is working fine with out any selection, after made the selection of any month its not working properly(Showing '0').

Please suggest on this.

Below is the Set Analysis Expression

sum({<Financial_Year={$(=max(Financial_Year))},MonthName={"$(=MonthName(max(MonthName)-1))"}>} [Value] ))/1000000

Thanks in Advance,

regards,

topic Issue With previous month set analysis expression in QlikView

Issue With previous month set analysis expression