Comparing two different year ?

[#1]

need to compare two different years ( 2011 and 2010) using variables.

Can any one help.

tnx

[#2]

I have used :

SUM({<Year = {'$(=Max(Year)-3)'}>}Sales)                //2011

SUM({<Year = {'$(=Max(Year)-4)'}>}Sales)             // 2014

The problem is that, i can not see both lines graphs  at the same time for comparison.

[MK_QSL]

Keep Month as Dimension

[#4]

You are right for  the st expression.

but why can not i see comparison graph like this : (I can not see it )

   http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

[its_anandrjs]

Exactly you not get it depends on the value in the fields in your model like month and Year values. Also after creating line chart format the line chart like click on the expression >> Display options >> Select Smooth from the options.

[SunilChauhan]

You need to take Monthyear Inpace of month then it will look like graph

Create monthYear field

MonthName(Date) as MonthYear and take as dimension

use same expressions as provided above posts

hope this helps

[its_anandrjs · Accepted solution]

After taking line chart and adding Dimension and Expression

Dimension:-Month

Previous Year

Sum({<Year = {'$(=Max(Year)-1)'}>}Sales)         

And

Current Year

Sum({<Year = {'$(=Max(Year))'}>}Sales)  

See the snap shot of the Line chart with the Month Dimension and Expression for current and previous

[SunilChauhan]

No need to take two expression

simply Take month and year in dimension

and  expression

sum({<Year={'2010','2011'}>} Amount)

hope this helps

[SunilChauhan]

even expression

sum({<Year={'2010','2011'}>} Amount)

can be dynamic

like below

sum({<Year={">=$(=Max(Year))"}>}Amount)

this helps you to compare current Year Vs previous Year

hope this helps

[#10]

Thanks a lot.

It worked very well

[MK_QSL]

The same answer I have given long time ago !!