topic Year over Year line chart - Daily Data in QlikView

Year over Year line chart - Daily Data

Tue, 06 Sep 2011 17:59:37 GMT

Please see the attached file. I want to show a year over year line chart based on daily data or 7 day moving average. Currently 2010 and 2011 data points are showing up continuously on the X-axis. Instead, i would like to display 2011 data on top of 2010.

Hope it makes sense.

Thanks.

Year over Year line chart - Daily Data

Tue, 06 Sep 2011 19:06:09 GMT

Hi Deepkohlitvna ,

May be you have to change your expressions or you have to change your dimension into a calculated dimension for separate years , Try to change your expressions from if conditions to set-analysis coding year(date)='2010' and similarly for year 2011.

the lines are continuing because of not using any year limitation for specified year in your expression and continution of dates in the dimension from 2010 to 2011 .

hope it helps

thanks

Meher

Year over Year line chart - Daily Data

Wed, 07 Sep 2011 13:33:54 GMT

Doesn't seem to work. Can't get 2011 to overlap 2010.

Year over Year line chart - Daily Data

Wed, 07 Sep 2011 14:07:48 GMT

You need to map your dates to Day # in FY (i prefer to use business days and combine sat and sundays but this is an example) Then use Day # in Year as your chart dimensino so 1/1/10 will be on same axes point as 1/1/11

Date	Day # in Year
1/1/2010	1
1/2/2010	2
1/3/2010	3
1/4/2010	4
1/5/2010	5
1/1/2011	1
1/2/2011	2
1/3/2011	3
1/4/2011	4
1/5/2011	5

Year over Year line chart - Daily Data

Wed, 07 Sep 2011 15:28:29 GMT

I think I am missing something here. When I use Day # in Year, my X-axis now shows Days from 1 till 365 but the data on the line chart is the sum of 2010 and 2011 instead of separate lines, eventhough I am using separate expressions for 2010 and 2011.

Year over Year line chart - Daily Data

Wed, 07 Sep 2011 15:43:28 GMT

this is the code use for my daily average charts. I create one expression for each period. In my case this is quarters and the axes is Day# in FQ comparing current qtr to last qtr and same qtr last year.

rangeavg

( above( sum({$<NumFYQTR={$(=Max(NumFYQTR,2))},[Subscription Indicator]={'$(=vProdorSub)'},[Vert-Horz]={"Vertical"},[Sales Type] = {"Commercial"},[WWS Sub Geo] = {"North America"}>} [TOTAL BOOKED ($)]), 0, RowNo()) )

Year over Year line chart - Daily Data

Thu, 08 Sep 2011 15:36:57 GMT

Thanks debbiepy. It worked.