Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

display 2 chart's in one line chart

Hi,

I have a problem to display a line chart :

The chart should display summed values over two dimensions and an average of that value over only one dimension.

More clear description in the attached qvw

QlikTech Support can't help me.

Thank's for your help,

Polo

4 Replies
Not applicable
Author

Hi

Can't you just put the 2nd chart "on top" of the first one and set the transparency to 100% under Chart properties->Colors.
You have the same dimension for your x-axis so it shouldn't cause any problems.

/Fredrik

johnw
Champion III
Champion III

I've overlayed quite a few charts, and that's probably your easiest solution. Note that you'll have to use a "static" maximum on the axes to make sure the charts will always line up. Might need to play some other games as well. And you'll only be able to get pop ups from the top chart.

You might also be able to add a fake extra LEGAL ENTITY value, "Average", using a calculated dimension. Then just check the value of the dimension to decide which formula to use. I'm not sure about the details. Just sounds like something that would be possible and might be more robust than merely overlaying two charts.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

One alternative is to use a Combo chart with the first dimension being a bar and the second a line.

-Rob

Not applicable
Author

Thank you for your answers.

I had already tested these solutions 🙂

I need necessarily a line chart, so I'm going to continue to use the transparency, but I find that it's not very evident to maintain (I have 8 charts as this one)

Polo