topic Calculating prior month based on selection in QlikView

Calculating prior month based on selection

Fri, 20 Sep 2013 02:21:25 GMT

I am calculating sum for current month and prior month based on the selection, for if I select 2013 January, it calculate Revenue for 2013 january under current month and 2012 december for prior month. As soon as I select the current month it automatically calculates for current month.How do we calculate for prior month? if I select the month for Jan 2013 it should calculare for december 2012. I really need help on this.

Thanks,

Abhi

Re: Calculating prior month based on selection

jagan — Fri, 20 Sep 2013 02:28:02 GMT

Hi,

IF you have a Date Dimension try this

=Sum({<YearDimension=, MonthDimension=, Date={'>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))'}>} Sales)

Hope this helps you. If not works can you attach some sample data.

Regards,

Jagan.

Re: Calculating prior month based on selection

Fri, 20 Sep 2013 12:49:33 GMT

Works like a Champ Jagan, Thank you Sir!

Re: Calculating prior month based on selection

jagan — Fri, 20 Sep 2013 14:55:55 GMT

Hi,

Please close this discussion if it helps you by giving correct answer to my post. It helps others in finding the answers for similar type of solutions.

Regards,

Jagan.

Re: Calculating prior month based on selection

Fri, 20 Sep 2013 15:00:47 GMT

How to close the discussion here?

Re: Calculating prior month based on selection

jagan — Fri, 20 Sep 2013 15:54:41 GMT

Hi,

Please click the Correct Answer to my post.

Regards,

Jagan.