Combining two line charts into one

[#1]

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.

[#2]

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

[Anonymous · Accepted solution]

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...])

[#4]

Many thanks Michael. It works!!!

Regards,

Sebastian