topic Re: Current Years Current Month Vs Last Year Same Month Sales in QlikView

Current Years Current Month Vs Last Year Same Month Sales

nirav_bhimani — Sat, 23 Mar 2013 07:01:59 GMT

Hi All,

I am getting problem in calculating last Year Month Sales on Selection,

I have tried two set expression for that but in both the cases my expression working only when I am not selecting anything, If I select anything then it wont show any data. I am also attaching Sample Data.

eg.

Please provide any alternative for that.

Thanks & Regards,

Nirav Bhimani

Re: Current Years Current Month Vs Last Year Same Month Sales

udit_kumar_sana — Sat, 23 Mar 2013 08:18:40 GMT

Hi Nirav,

Please find here the attached file for the solution of your issue.

Regards,

Udit

Re: Current Years Current Month Vs Last Year Same Month Sales

jagan — Sat, 23 Mar 2013 08:23:15 GMT

Hi Nirav,

Use this expression for

Current Year Current Month

=Sum({<CalYear=, CalMonthYear=, CalMonth=, CalQuarter=, CalDate={'>=$(=MonthStart(Max(CalDate)))<=$(=MonthEnd(Max(CalDate)))'}>} Sales)

Last Year Current Month

=Sum({<CalYear=, CalMonthYear=, CalMonth=, CalQuarter=, CalDate={'>=$(=MonthStart(Max(CalDate), -12))<=$(=MonthEnd(Max(CalDate), -12))'}>} Sales)

Hope this helps you.

Regards,

Jagan.