topic Re: Comparing two different year ? in QlikView

Comparing two different year ?

Tue, 29 Apr 2014 13:58:16 GMT

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

Can any one help.

tnx

Re: Comparing two different year ?

MK_QSL — Tue, 29 Apr 2014 13:59:17 GMT

SUM({<Year = {'$(=Max(Year))'}>}Sales) //Current Year

and

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales) // Previous Year

Now you can compare them

Re: Comparing two different year ?

its_anandrjs — Tue, 29 Apr 2014 14:00:16 GMT

Write a variable like

let vCurrYear = 2011

Let vPrevYear = 2010

and in expression use this variavbles

Re: Comparing two different year ?

its_anandrjs — Tue, 29 Apr 2014 14:03:14 GMT

Update now check

If you want to compare only 2011 and 2010

then write

2011

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

And

2010

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

Re: Comparing two different year ?

Tue, 29 Apr 2014 14:07:59 GMT

Thanks .

But i would like to depict them on line graphs ?

Re: Comparing two different year ?

MK_QSL — Tue, 29 Apr 2014 14:11:53 GMT

Let us know your requirement with dummy data...

Re: Comparing two different year ?

Tue, 29 Apr 2014 14:19:02 GMT

Thanks

i was thinking just like this :

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

Re: Comparing two different year ?

MK_QSL — Tue, 29 Apr 2014 14:24:59 GMT

Create a line chart

Dimension

Month

Expressions

SUM({<Year = {'$(=Max(Year))'}>}Sales) //Current Year

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales) // Previous Year

Re: Comparing two different year ?

tresB — Tue, 29 Apr 2014 14:27:47 GMT

So, is there anything specific there in the blog that you don't understand? Otherwise, it explains very nicely, right?

Re: Comparing two different year ?

its_anandrjs — Tue, 29 Apr 2014 14:32:45 GMT

You can make chart with any dimension like

Take a line chart

Dimension :-Year ,Month

Expression1:- for 2011

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

And

Expression2:- for 2010

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

If you want to plot chart for current year and previous year then use

Dimension:-Month

Previous Year

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

And

Current Year

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

Re: Comparing two different year ?

Tue, 29 Apr 2014 14:45:21 GMT

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.

Re: Comparing two different year ?

MK_QSL — Tue, 29 Apr 2014 14:50:04 GMT

Keep Month as Dimension

Re: Comparing two different year ?

Tue, 29 Apr 2014 14:50:37 GMT

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

Re: Comparing two different year ?

its_anandrjs — Tue, 29 Apr 2014 15:11:30 GMT

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.

Re: Comparing two different year ?

SunilChauhan — Tue, 29 Apr 2014 15:15:38 GMT

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

Re: Comparing two different year ?

its_anandrjs — Tue, 29 Apr 2014 15:24:11 GMT

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

Re: Re: Comparing two different year ?

SunilChauhan — Tue, 29 Apr 2014 15:43:01 GMT

No need to take two expression

simply Take month and year in dimension

and expression

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

hope this helps

Re: Comparing two different year ?

SunilChauhan — Tue, 29 Apr 2014 15:47:56 GMT

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

Re: Comparing two different year ?

Wed, 30 Apr 2014 07:22:54 GMT

Thanks a lot.

It worked very well

Re: Comparing two different year ?

MK_QSL — Wed, 30 Apr 2014 07:24:34 GMT

The same answer I have given long time ago !!