topic Re: Line chart in QlikView

Line chart

ishika00730 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to create a chart where I have to show Total Order Placed and out of it how many orders have been delivered.

I am using Month as dimension and 2 expressions. One expression shows total Orders Placed. 2nd expression shows Delivered Orders. But when I put it in a line chart (area one) the lines get Stacked on top of each other.

EX: Total Line and on top of it Delivered Orders Line.

But my requirement is to show Orders Placed Line and following it is the Delivered Orders.

If someone can suggest how, it would be a help.

Many Thanks

Ishika Gupta

Re: Line chart

dialika_bantog — Mon, 27 Aug 2018 03:13:44 GMT

How about using a combo chart instead?

Re: Line chart

Lisa_P — Mon, 27 Aug 2018 04:20:14 GMT

If you are using QlikView, go to the properties and check the Style tab. You should be able to select Grouped rather than Stacked

Re: Line chart

pooja_prabhu_n — Mon, 27 Aug 2018 05:51:55 GMT

Hi,

If total order placed approximately equal to total order delivered , then there are chances of overlapping of both the lines.

If possible can you share some sample app?

Thanks,

Pooja

Re: Line chart

Anonymous — Mon, 27 Aug 2018 05:52:04 GMT

Hi Ishika,

As you are selecting two expressions on same axes and wheras both the expression might have very little diversion

so it will overlap on each other.

But as per your requirement we can do using split Axis Functionality of qlikview.

PFA screenshot

Regards

Ritesh kodolikar

Re: Line chart

ishika00730 — Mon, 27 Aug 2018 06:11:46 GMT

Hi Lisa,

But unfortunately its a line chart. The option to click on "Grouped" / "Stacked" is disabled.

Any other option to try?

Thanks

Ishika

Re: Line chart

ishika00730 — Mon, 27 Aug 2018 06:13:00 GMT

Hi Pooja,

No the difference is huge and I need to show the total orders placed in a line chart (the area one) and within that I have to show how many orders have been delivered.

Any option to try?

Regards

Ishika

Re: Line chart

Anil_Babu_Samineni — Mon, 27 Aug 2018 06:59:00 GMT

Better if you can share sample application

Re: Line chart

ishika00730 — Tue, 28 Aug 2018 04:48:02 GMT

Business only wants to see a line chart. Something like the attache.

Many Thanks

Ishika