topic Combining two line charts into one in QlikView

Combining two line charts into one

Sat, 16 Oct 2010 10:23:41 GMT

Hi,

I'm trying to combine two line charts that have the same dimensions but two different expressions.

One dimension is a numeric value (showed on X axis) and the second dimension have two possible values.

On each line chart I have two lines showed. (see the middle and the right on the attached image)

Now I would like to create a combined chart (one qv object) that would show 4 lines and Y axis would be split.

When I created a new line chart with the same two dimensions and two expressions I still get only 2 lines (instead of 4) and the plotted lines are the average (see the left chart on the attached image)

It is possible to create such plot in QlikView?

I was thinking about making one object transparent and putting it onto the second but this is not what I want because later I need to print that chart.

Combining two line charts into one

Sat, 16 Oct 2010 10:42:27 GMT

Just to make this more clear I attach a pivot table. I would like to plot this 4 columns on one line chart.

Combining two line charts into one

Anonymous — Sat, 16 Oct 2010 20:39:49 GMT

I think you can do it by using one dimension (Epsilon) and 4 expressions:
avg({$<"2ndDimension"={'length fitness'}>} [Average r...])
avg({$<"2ndDimension"={'length fitness'}>} [Average d...])
avg({$<"2ndDimension"={'overlap fitness'}>} [Average r...])
avg({$<"2ndDimension"={'overlap fitness'}>} [Average d...])

Combining two line charts into one

Sat, 16 Oct 2010 21:03:25 GMT

Many thanks Michael. It works!!!

Regards,

Sebastian