Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combining two line charts into one

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.

error loading image

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

3 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Not applicable
Author

Many thanks Michael. It works!!!

Regards,

Sebastian