topic How to calculate Previous Month Sales? in QlikView

How to calculate Previous Month Sales?

Thu, 31 Jul 2014 14:19:11 GMT

Hi All

I have Month and Year in my data(no date) along with say Sales.

Now the requirement is to calculate Prev Month Sales data on the basis of the month selected.

Any ideas how can I achieve this?

How should I go about creating the Master Calendar without the date.

P.S: I know I can use dummy date by finding out the minimum of year and calculating min and max dates and use it to create my Master Calendar, but is there some other way.

Best Regards

Sabal

Re: How to calculate Previous Month Sales?

Thu, 31 Jul 2014 14:24:23 GMT

Hi Sabal,

you can use the makedate() function to generate a date from your year and month fields and use that as the basis for your master calendar.

Also if you created your month field with the Month() function, you'll be able to use set analysis with <=Max(Month)

to get your prior months

hope that helps

Joe

Re: How to calculate Previous Month Sales?

Thu, 31 Jul 2014 14:45:08 GMT

Hi Joe,

Thanks for the reply.

I know I can use the MakeDate() function(dummy date) but I was wondering if there is any other way to create the Master Calendar(without the date).

Thanks

Sabal

Re: How to calculate Previous Month Sales?

Thu, 31 Jul 2014 15:40:39 GMT

hmm not really, the whole idea of a master calendar is to generate from a date. Might be able to come up with a solution that doesn't require creating one though (and just use your current fields), are you able to knock an example together