topic Re: Area & Line Chart Combo in QlikView

Area & Line Chart Combo

Anonymous — Wed, 12 Nov 2014 14:40:46 GMT

Fellow Qlikviewers,

as per request I am trying to convert some Excel-graphs into our Qlikview environment.

We have several graphs that use a combination of a Area-chart and a Line-chart (see image below).

I have not yet found the option to create a graph that will do both.

Does anyone have a solution / workaround?

Thanks in advance for any help/suggestion!

Re: Area & Line Chart Combo

Gysbert_Wassenaar — Wed, 12 Nov 2014 18:04:33 GMT

The workaround is to put two charts on top of each other. See attached example

Re: Area & Line Chart Combo

Anonymous — Thu, 13 Nov 2014 07:55:06 GMT

Gysbert, thanks for you help! One slight problem: we are still waiting for the Qlikview Licenses, so at the moment I'm working on a free version and can't open your file. Would it be possible to explain shortly how you make two charts on top of each other? Thanks in advance again!

Re: Area & Line Chart Combo

Anonymous — Wed, 26 Nov 2014 09:03:39 GMT

Any luck with explaining 'in words' how to do this?

Thanks again!

Re: Area & Line Chart Combo

jyothish8807 — Wed, 26 Nov 2014 09:08:41 GMT

Hi Stefan,

Try to create two different graph 1. Line chart and other Area chart with same dimension and expression.Place them on each other.

And yes , you have to set transperancy to 100% for one chart.

Hope it helps.

Regards

Re: Area & Line Chart Combo

Wed, 04 Feb 2015 11:43:00 GMT

hi Gysbert,

I too need a combo of line and area chart in a single graph,Can you elaborate on what you are trying to convey...Thanx in advance