Line Chart to show last 6 months

Tue, 09 Sep 2014 14:35:15 GMT

Been struggling with this one for a while and although I find info on here it doesn't seem to do what I want or I can't get it to work at all.

I have attached my qvw file with a graph. The layout is there or there about's, but I would like it to show the last six weeks/months of data regardless of filters.

Dimensional limits don't work as there is no latest/last option.

I have been trying expressions like the one below but it only seems to group the last X months together in one column

=Sum({< YearDimensionName=, QuarterDimensionName=, MonthDimensionName =, DateDimensionName= {'>=$(=MonthStart(Max(DateDimensionName), -5))<=$(=Date(Max(DateDimensionName)))'}>} MeasureName)

Any help appreciated.

Re: Line Chart to show last 6 months

Wed, 10 Sep 2014 14:11:30 GMT

Steve,

If I understood you right, you want the last 6 month bzw. 6 weeks to be displayed.

First: how do you detect if you want to see weeks or months?

To the solution:

Switch off any dimension limits
In the Presentation tab, activate 'Enable X-Axis Scrollbar'
Set 'When Number of Items Exceeds' to 6 (or whatever suits you)
activate 'Reversed' so it will take the 6 last values

Should now display the last 6 months/ weeks only, just as you wish.

I guess with that solution you can use simple expressions

Hope that did help!

Best regards!

Moritz

P.S. See the attached file where I did what I wrote above

topic Re: Line Chart to show last 6 months in QlikView

Line Chart to show last 6 months

Re: Line Chart to show last 6 months