topic Re: Line chart showing Current and Previous Year in QlikView

Line chart showing Current and Previous Year

n1ef5ng1 — Fri, 11 Apr 2014 07:23:29 GMT

I have this line chart dimension is

1) Month

2) Year

On the expression, I have

1) sum(Sales)

I would like the line chart to show two line chart, current year (2014) and previous year (2013) without user to make any selection.

Is there anything that I can edit on the Year Dimension to show 2013 and 2014 as for this year? Current and previous year

nizamsha — Fri, 11 Apr 2014 07:26:51 GMT

In Dimension u can write

If(year>2012,Year)

Another Month as Dimension and expression as sum(Sales)

nizamsha — Fri, 11 Apr 2014 07:29:24 GMT

U can do this in another way if u like mean

Month as Dimension

write 2 expression one for current year and one for previous year

like this

Sum({$<year={"$(=Max(Year))"}>}Sales) for Current Year

Sum({$<year={"$(=Max(Year)-1)"}>}Sales) For previous Year

n1ef5ng1 — Fri, 11 Apr 2014 07:30:40 GMT

this will be 'hard coding' way, tedious to maintain when years to come

Fri, 11 Apr 2014 07:33:32 GMT

HI, Benn.

=if( Year>=Year(AddYears(today(),-1)), Year)

and Suppress When Value Is Null Check, If you want.

a year later, can be sustain