topic Re: How do I get the previous MonthYear on a chart? in QlikView

How do I get the previous MonthYear on a chart?

Mon, 25 Feb 2013 09:34:35 GMT

Thank you for helping me get the current MonthYear on the chart. I thought that getting the previous MonthYear would be quite straighforward once getting the current one was established, but it isn't.

It is the MonthYear from one year ago that I'm trying to get and I'm putting it in the second column of the aggr pivot table next to the current MonthYear.

I have managed to get the previous MonthYear to show in a text box, but if I put that exact formula inside quotes in the expression then I just get zeroes.

I can't figure out why this isn't working. Anybody know why?

Re: How do I get the previous MonthYear on a chart?

sujeetsingh — Mon, 25 Feb 2013 09:43:07 GMT

Inthe text box you can get previous month as

=(Date(monthstart(max(Date)-365) -1, 'MMM-YYYY') )

Re: How do I get the previous MonthYear on a chart?

Mon, 25 Feb 2013 09:50:10 GMT

The text box gives me what I want no problem, it's the expression in the chart where I can't get it to work.

Re: How do I get the previous MonthYear on a chart?

Mon, 25 Feb 2013 10:01:38 GMT

Apart from a couple of syntax errors, you also have to undo the Year and Month filters, to have values for the last year in your expression. Try this one:

sum({$<MonthYear = {'$(=Date(monthstart(max(Date)-365), 'MMM-YYYY'))'}, Year=, Month=>} LineSalesAmount)

Juan Gerardo

Re: How do I get the previous MonthYear on a chart?

Mon, 25 Feb 2013 10:17:45 GMT

Thank you, it works.