topic Re: Combo chart help in QlikView

Combo chart help

Mon, 25 Jan 2016 22:15:39 GMT

Hi - I have a bar chart (attached), but I would like to display three trend lines on the same chart, one for each Department. So one for Rice LP, Rice NV and Snack. Thank you for your help!

Re: Combo chart help

Mon, 25 Jan 2016 22:20:40 GMT

The bar chart is actually behind the line chart, but all the everything is the same in both except for the chart type...

Re: Combo chart help

Anonymous — Mon, 25 Jan 2016 23:14:58 GMT

Use a Combo chart and as well as your current expressions displayed as bars, create 3 expression displayed as lines.

Re: Combo chart help

sunny_talwar — Tue, 26 Jan 2016 00:06:37 GMT

Something like this?

This is a Combo chart, just as Bill has mentioned above. But what I don't understand is how is this going to be helpful which so much going on? Do you find this a good way to visualized the data? I don't know the answer, but just something to think about.

Re: Combo chart help

Wed, 27 Jan 2016 22:32:10 GMT

You're right - there is too much going on there. I guess I don't need the bars. I do need the three lines comparing each department. Can you show me what you did to create that? Thank you!!!

Re: Combo chart help

sunny_talwar — Wed, 27 Jan 2016 22:42:41 GMT

I did three expressions:

=Sum({<Department = {'Rice LP'}>}Percentage)

=Sum({<Department = {'Rice NV'}>}Percentage)

=Sum({<Department = {'Snack'}>}Percentage)

Alternatively you can also add Department as your second dimension with just Sum(Percentage) as your expression.

PFA the application

Re: Combo chart help

Wed, 27 Jan 2016 23:03:39 GMT

Thank you! Is there a way to get rid of the extra trend lines, so each department has one line instead of two?