topic Re: Limiting the months on a graph in QlikView

Limiting the months on a graph

Thu, 27 Jun 2013 08:45:12 GMT

Hi There,

I am trying to limit my bar chart to show only the last three months instead of all months.

Is there a simple peice of code I can use that will do this automatically?

My graph currently shows sales figures for Feb,Mar,Apr,May,Jun.

I would like it to only show Apr, May, Jun and when it brings in July figures in July I would like it to drop Apr and just show May,Jun,Jul.

Is this possible?

In the attachment below I have shown what it currently looks like. The dimension is Month/Year.

Would greatly appriciate the help.

Thanks

pennetzdorfer — Thu, 27 Jun 2013 08:53:00 GMT

This blog post of Henric Conström will help you out:

The clue is creating a new field (MonthAgo) in the script and using it in your expression (set analysis).

Regards,

Florian

narender123 — Thu, 27 Jun 2013 08:56:23 GMT

I set analysis.

Month={'>=$(=max(Month)-2)'}

Thanks.

Narender

narender123 — Thu, 27 Jun 2013 08:56:29 GMT

I set analysis.

Month={'>=$(=max(Month)-2)'}

Thanks.

Narender

er_mohit — Thu, 27 Jun 2013 09:08:28 GMT

try this

Sum({<Month = {">=$(=max(Month)-2)"}>}sales)

Thu, 27 Jun 2013 09:25:09 GMT

That's brilliant thanks everyone for your help, the set is working.

Much appriciated.