topic Re: Selected Month - Previous Month in QlikView

Selected Month - Previous Month

Fri, 03 Aug 2012 06:48:50 GMT

I have data from 2007 to 2012, whenver i will select any month from any year i want update the sheet with selected month and previous month....so how can we use the set analysis here...

Re: Selected Month - Previous Month

jagan — Fri, 03 Aug 2012 06:59:47 GMT

Hi Anil,

Check this expressions

For Previous Month

=Sum({<Year=, Month=, DateOfService={'>=$(=MonthStart(Max(DateOfService), -1))<=$(=MonthEnd(Max(DateOfService), -1))'}>} Sales)

For Current Month

=Sum({<Month=, Year=,DateOfService={'>=$(=MonthStart(Max(DateOfService)))<=$(=Max(DateOfService))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

Re: Selected Month - Previous Month

daveamz — Fri, 03 Aug 2012 07:57:17 GMT

Hello,

See the example in the file attached.

Regards,

David