topic Re: line and bar chart when merged in QlikView

line and bar chart when merged

Tue, 23 Feb 2016 08:24:22 GMT

Hi,

I would like to have these 2 charts merged but when I place the 2 expressions in the chart, the lines get weird (2nd pic)

I was thinking that it should be plot as still 3 distinct lines

any assistance is much appreciated.

Re: line and bar chart when merged

Oleg_Troyansky — Tue, 23 Feb 2016 19:49:08 GMT

Hi Grace,

I don't think these two charts can be combined into one, because of the two dimensions that you have. If you could tweak your chart into a single-dimensional chart by Quarter (each Service would have to be a separate Expression then), - that would make it possible.

Alternatively, as a work-around, you can try to overlay two separate charts with transparent backgrounds, but that's a bit tricky... You''ll have to ensure exactly the same placement of your dimensional values and to suppress some of the texts with transparent backgrounds.

cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy and Austin, TX!

Re: line and bar chart when merged

Wed, 24 Feb 2016 08:55:15 GMT

Hi,

Thank you for confirming that it is not possible, much appreciated.

Will do them as 2 charts side by side.

regards,

grace

Re: line and bar chart when merged

oknotsen — Wed, 24 Feb 2016 10:44:19 GMT

If your question is now answered, please flag the Correct Answer.

If not, please let us know what part of your question you still need help with .