Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Selected Month - Previous Month

Hi

    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...

2 Replies
MVP
MVP

Re: Selected Month - Previous Month

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.

daveamz01
Contributor III

Re: Selected Month - Previous Month

Hello,

     See the example in the file attached.

Regards,

David

Community Browser