topic Re: How to display Last 12 Month in Dimension in Bar Chart in QlikView

How to display Last 12 Month in Dimension in Bar Chart

Fri, 15 May 2015 06:52:37 GMT

Hi,

In my requirement, I want to show last 12 months data in dimension in dar chart.

EX:

Dimension : Month Year ( Api-2015 )

Expression : Count (Items).

the data is from 3 Years. i Want to show only 12 months dynamically.

any one help on this.

Regards,

Chennaiah

Re: How to display Last 12 Month in Dimension in Bar Chart

jonathandienst — Fri, 15 May 2015 07:09:46 GMT

I would usually use a set filter on the expressions to limit data to the last 12 months, like

Sum({<Date = {">=$(=AddMonths(Max(Date), -12))"}>} Sales)

Re: How to display Last 12 Month in Dimension in Bar Chart

Fri, 15 May 2015 07:27:44 GMT

I have something similar, hope this will help.

On the Dimension limits tab, select Restrict which values are displayed, then in show only, select Largest in the Dropdown, and then 12 in Value.

I used it in a rolling 12 month stacked bar chart, works fine, then you have the calculation in the expression field.

Re: How to display Last 12 Month in Dimension in Bar Chart

mohammadkhatimi — Fri, 15 May 2015 07:29:32 GMT

=sum({1<DATE={'>=$(=MonthStart(Max(Date_field),-12))<=$(=MonthEnd(Max(Date_field),-1))'}>}Sales)

Try above expression

Hope it helps you..

Regards,

Mohammad

Re: How to display Last 12 Month in Dimension in Bar Chart

Fri, 15 May 2015 08:37:23 GMT

Thanks Andret,

But it showing between Api-2014 to Mar-2015, it not showing current month EX May 2015

Re: How to display Last 12 Month in Dimension in Bar Chart

mohammadkhatimi — Fri, 15 May 2015 09:51:07 GMT

Try this:

=sum({1<DATE={'>=$(=MonthStart(Max(Date_field),-12))<=$(=MonthEnd(Max(Date_field)))'}>}Sales)

Re: How to display Last 12 Month in Dimension in Bar Chart

Fri, 15 May 2015 10:24:12 GMT

Strange, are you sure everything is right, do yo have data for April and May 2015, this could give wrong values if you have missing months. have not picked up this problem myself, mine is working 100%. Maybe check your load order. Check the Sort tab as well, maybe the sorting is wrong. Can you maybe give a reduced data model with some records for each of the periods?

Re: How to display Last 12 Month in Dimension in Bar Chart

amit_saini — Fri, 15 May 2015 10:30:36 GMT

Hi,

See the attachment.

Thanks,
AS