topic Re: Year on Year comparision in QlikView

Year on Year comparision

soha1902 — Tue, 18 Aug 2015 05:58:44 GMT

Hi All,

I have two Fiscal Year of Data. lease see following images:

I want to implement the Year on Year comparison in single chart.

For Example if user select 2014-2015 then previous will be 2013-2014. My fiscal year start from July to June like its coming in chart.

Thanks.

Re: Year on Year comparision

senpradip007 — Tue, 18 Aug 2015 06:03:53 GMT

Try to use these expressions;

For Current Year: Sum({<FiscalYear={$(=Max(FiscalYear))}>} DataField)

For Previous Year: Sum({<FiscalYear={$(=Max(FiscalYear)-1)}>} DataField)

Re: Year on Year comparision

soha1902 — Tue, 18 Aug 2015 06:07:58 GMT

Hi Pradip,

I can not use Max(FiscalYear)-1 directly..see Fiscal year format.

Re: Year on Year comparision

senpradip007 — Tue, 18 Aug 2015 06:11:12 GMT

Can you upload some sample data with expected output?

Re: Year on Year comparision

soha1902 — Tue, 18 Aug 2015 06:36:34 GMT

See the image its is showing the selected year...I want to add one more line in the same chart for previous Year.

Sample file is attached. But please share the script as I am using Personal Edition.

Re: Year on Year comparision

soha1902 — Tue, 18 Aug 2015 07:10:54 GMT

Any Suggestions Plz.

Re: Year on Year comparision

senpradip007 — Tue, 18 Aug 2015 07:29:05 GMT

PFA. Hope it will help.

Re: Year on Year comparision

kavita25 — Tue, 18 Aug 2015 07:52:18 GMT

Please refer the link:

Qlik Design Blog : Year-over-Year Comparisons | Qlik Community

Regards,

Kavita

Re: Year on Year comparision

jsingh71 — Tue, 18 Aug 2015 08:19:24 GMT

Follow This:

Create two variables

vCurrent = left(FiscalYear,4)&'-'&(left(FiscalYear,4)+1)

vPrevious = Left(FiscalYear,4)-1&'-'&Left(FiscalYear,4)

Now In Chart Selection FiscalMonth Dimension as you are using the same and write following two expressions:

Current Year: Sum({<FiscalYear={'$(vCurrent)'}>} <Your Field>)

Previous: Sum({<FiscalYear={'$(vPrevious)'}>} <Your Field>)

Hope This will work.

Re: Year on Year comparision

Tue, 18 Aug 2015 11:28:55 GMT

Alternatively you could use 2 lists boxes corresponding to different alternate states and then call

State A from expression 1

State B from expression 2

this way you could compare any 2 years and aren't locked in year and year -1