Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Line chart...each line representing a different year

I am trying to create a line chart of sales by month (x axis) with each year represented by a different line in the chart. Sales Year, Sales Month, and Gross Sales are all separate dimensions in the same table.  The table represent 4 years worth of data.  Not sure how to handle this through Expresssions. 

Any help would be appreciated.

1 Solution

Accepted Solutions
Not applicable

Re: Line chart...each line representing a different year

Just add another dimension for the Year,

So your dimensions would be Month, and Year.

Leave the expression as it is.

4 Replies
Not applicable

Line chart...each line representing a different year

Can you post an example on how the data is currently displaying, and how you would like to see it displayed?

Not applicable

Re: Line chart...each line representing a different year

I have attached a screen shot showing both the chart and the properties box with the expression.  The chart is showing a line for Gross Written Premium for the sum of 2009, 2010, and 2011.  I need to display each year as a separate line over the months.

Not applicable

Re: Line chart...each line representing a different year

Just add another dimension for the Year,

So your dimensions would be Month, and Year.

Leave the expression as it is.

Not applicable

Re: Line chart...each line representing a different year

Thanks!  That worked.