topic Re: How to display previous year value in year wise line chart ? in QlikView

How to display previous year value in year wise line chart ?

Thu, 27 Dec 2012 05:14:23 GMT

Hello All ,

I am working on sales dashboard where it need to display previous year value in line chart where dimension is year.

Below is data which used to build the chart

Saleyear Saleqty

2007 100

2008 150

2009 180

2010 190

2011 175

2012 125

I have tried with set analysis but didn't work.

Re: How to display previous year value in year wise line chart ?

Thu, 27 Dec 2012 05:55:35 GMT

Hi,

If you take dimension as year and expression as salesqty then the line chart will show the data for all the years.. if you want to show only previous year value then use calculated dimension..

=max(year)-1

or based on selections you want show data for previous years means you have to create on variable and use that in calculated dimension..

=$(vyear)-1

Re: How to display previous year value in year wise line chart ?

jagan — Thu, 27 Dec 2012 06:29:00 GMT

Hi,

Please find attached file.

Hope it helps you.

Regards,

Jagan.

Re: How to display previous year value in year wise line chart ?

Thu, 27 Dec 2012 06:30:32 GMT

As ur Requirement U want to display the data like below ryt?

Saleyear Saleqty

2007 -

2008 100

2009 150

2010 180

2011 190

2012 175

~ Kabilan K

Re: How to display previous year value in year wise line chart ?

er_mohit — Thu, 27 Dec 2012 06:42:49 GMT

use this expression

sum({$<saleyear={$(#=only(Saleyear)-1)}>}Saleqty)

hope it helps you

Re: How to display previous year value in year wise line chart ?

Thu, 27 Dec 2012 06:48:08 GMT

try according to this,

Examples:

sum( {$<Year = {$(#vLastYear)}>} Sales )
returns the sales for the previous year in relation to current selection. Here, a variable vLastYear containing the relevant year is used in a dollar-sign expansion.

sum( {$<Year = {$(#=Only(Year)-1)}>} Sales )
returns the sales for the previous year in relation to current selection. Here, a dollar-sign expansion is used to calculate previous year.

hope it helps you.

Re: How to display previous year value in year wise line chart ?

nirav_bhimani — Thu, 27 Dec 2012 07:25:23 GMT

Hi,

Try this.

For Current Year:

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

Last Year Sales:

Sum({<Year= {"$(=Max(Year)-1)"},Quarter=,Year=>}Sales)

2 Year Back

Sum({<Year= {"$(=Max(Year)-2)"},Quarter=,Year=>}Sales)

Regards,

Nirav Bhimani

Re: How to display previous year value in year wise line chart ?

Mon, 31 Dec 2012 10:48:10 GMT

I have tried this one still it is showing output as per below data

Saleyear	Saleqty	LY Qty
2007	100	100
2008	150	150
2009	180	180
2010	190	190
2011	175	175
2012	125	125

Please see attached file and help me on this.

Re: How to display previous year value in year wise line chart ?

Mon, 31 Dec 2012 10:49:11 GMT

didn' work for me .

Please see below I have given to Nirav Bhimani

Re: How to display previous year value in year wise line chart ?

Mon, 31 Dec 2012 10:49:41 GMT

didn't work . Please see reply given by me to Nirav Bhimani

Re: How to display previous year value in year wise line chart ?

Mon, 31 Dec 2012 10:50:12 GMT

Can't be usefull in my case that why not tried .

Please see reply given by me to Nirav Bhimani

Re: How to display previous year value in year wise line chart ?

Mon, 31 Dec 2012 10:51:01 GMT

Correct. Can you help me on this.

FYI

Please see reply given by me to Nirav Bhimani where I have attached QVW file.

Re: How to display previous year value in year wise line chart ?

Mon, 31 Dec 2012 10:51:49 GMT

didn't work . Please see reply given by me to Nirav Bhimani

Re: How to display previous year value in year wise line chart ?

katharinakostka — Fri, 26 Aug 2016 10:06:45 GMT

Hi Kit,

I am courious: did you find an answer? And if yes:would you share it?

Regards