Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Year-over-Year Trending Graph

Does anyone know how to graph a comparative y/y? I want the graph to look like this:

error loading image

The QV data is in a two-dimension table like this:



MonthSales Volume
1/31/2007663.25
2/28/2007672.15
3/31/2007765.51
4/30/2007776.44
5/31/2007830.62
6/30/2007748.55
7/31/2007835.88
8/31/2007843.76
9/30/2007878.79
10/31/2007847.39
11/30/2007851.20
12/31/2007786.00
1/31/2008696.64
2/29/2008764.72
3/31/2008878.70
4/30/2008875.89
5/31/2008807.88
6/30/2008773.22
7/31/2008917.78
8/31/20081,109.32
9/30/2008823.75
10/31/2008839.87
11/30/2008734.93
12/31/2008864.93
1/31/2009838.23
2/28/2009646.93
3/31/2009804.08
4/30/2009750.71
5/31/2009776.80
6/30/2009723.55
7/31/2009909.66
8/31/2009859.06
9/30/2009884.46
10/31/2009810.95
11/30/2009774.06
12/31/20091,028.34
1/31/2010782.46
2/28/2010850.34
3/31/20101,074.08
4/30/2010891.20


I realize I could create a cross-table looking like this:

YearJanFebMarAprMayJunJlyAugSepOct
2007663.25672.15765.51776.44830.62748.55835.88843.76878.79847.39
2008696.64764.72878.7875.89807.88773.22917.781,109.32823.75839.87
2009838.23646.93804.08750.71776.8723.55909.66859.06884.46810.95
2010782.46850.341,074.08891.2


But given the volume of detail I'm dealing with (Jan '08 to present resulting in 200,000ish records), it's just impractical.

Any suggestions?

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Year-over-Year Trending Graph

Line chart with two dimensions, month(Month) and year(Month). Make them real fields instead of calculated dimensions for improved performance. See attached.

View solution in original post

2 Replies
Highlighted
MVP
MVP

Year-over-Year Trending Graph

Line chart with two dimensions, month(Month) and year(Month). Make them real fields instead of calculated dimensions for improved performance. See attached.

View solution in original post

Highlighted
Not applicable

Year-over-Year Trending Graph

I have been working on this for 2 days.  I knew the answer had to be very simple but I just could not get it.  THANK YOU so much!!!