Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to compare time periods on charts


Hi,

I'm trying to compare time periods on a chart in the following manner:

X axis = time periods (days / weeks / months)

Y axis = sales value

Each line on the chart should be one year (so 1 line for 2012, 1 line for 2013 etc.) so that I can compare what was the sales by weeks in year 2012 vs 2013.

How to do that on script or chart level

Many thanks

T

1 Solution

Accepted Solutions
carlos_reyes_qv
Valued Contributor

Re: How to compare time periods on charts

With a line chart.

First dimension: Day field or week field or Month field or a Cyclic or Drill Down group with all those fields.

Second dimension: Year field

Expression: sum of sales

Select 2012 and 2013 in Year field.

1 Reply
carlos_reyes_qv
Valued Contributor

Re: How to compare time periods on charts

With a line chart.

First dimension: Day field or week field or Month field or a Cyclic or Drill Down group with all those fields.

Second dimension: Year field

Expression: sum of sales

Select 2012 and 2013 in Year field.

Community Browser