topic Re: chart in QlikView

chart

Tue, 20 Aug 2013 12:42:27 GMT

Hi All,

I want to create a chart with product and year as dimensions and sum(sales).

What I want to do is: for all the year up to 2012 I want sum(sales) but for 2013 I want to have 12 rolling month (sales) ,lets say from july 2012 until now.

Anybody has any idea, I appreciate!

Thanks

Re: chart

Gysbert_Wassenaar — Tue, 20 Aug 2013 16:13:19 GMT

I think you'll need an AsOf table for this. See this document for an explanation. Your expression will then have to check if the year is 2013:

If(Year=2013,

sum({<Type={'Rolling 12'}>}Amount),

sum({<Type={'Current'}>}Amount)

)

Re: chart

Tue, 20 Aug 2013 18:53:38 GMT

Hi,

Thanks for the reply but I think something is missing !

As I see for 12 month as we have month from last year which is not corresponding the current year (2013), it does not show the 12 months correctly and it only shows the 2013 data.

I also added year in the asOfTable and it didn't help.

Any idea?

Thanks