topic Re: Combo Chart in QlikView

Combo Chart

Wed, 27 Nov 2013 11:39:59 GMT

Hi Folks,

I have a requirement to create Combochart with and without stacked bars. ( example attached ).

Would it be possible to create such chart in qlikview, your kind suggestion really needed.

Thank you.

Re: Cumbo Chart

saumyashah90 — Wed, 27 Nov 2013 11:53:41 GMT

Yes Combo chart is possible

Just right Click on blank sheet

NewSheetObject->chart->3rd tab(that is a combo chart

you give required dimensions and then you can get it

Re: Combo Chart

Wed, 27 Nov 2013 12:06:50 GMT

thank you Saumya for the posting.

however, if you see attached file. the requirement is to create Stacked combo. and that is a real challenge.

Regards,

Re: Combo Chart

saumyashah90 — Wed, 27 Nov 2013 12:16:09 GMT

Hi Gaurav,

It should not create any problem,

We have that feature too

Re: Combo Chart

Wed, 27 Nov 2013 12:21:30 GMT

Saumya,

I understand that too, but could you please see my attached file.

Combo + Stacked is still okay, but how do we achieve Combo with 3 expression where,

1. First expression is to draw line.

2. Second expression is to draw stacked bar

3. Third expression is to draw bar.

Regards,

Re: Combo Chart

saumyashah90 — Wed, 27 Nov 2013 12:39:30 GMT

Yeah Gaurav both(Stacked and Grou[ bars) on the same time is not possible in QlikView Combo chart

Re: Combo Chart

Wed, 27 Nov 2013 12:44:54 GMT

looking for some work around, if possible !

Re: Combo Chart

sicilianif — Wed, 27 Nov 2013 13:20:24 GMT

Just a thought, but an option might be to layer 3 charts:

1st chart would be bars for 1-7 days, received, delivered

2nd chart would be bars for 8-30 days (bar offset based on 1-7), received, delivered

3rd chart would be bars for 31+ (bar offset based on 1 -30), received, delivered

The lines could be on any of the charts.

You would have to play with the axis min/max to make sure everything lines up.

Re: Combo Chart

Thu, 28 Nov 2013 05:07:19 GMT

Thx Frank, for a sec I had a same thought. but then user wants to copy/export image. in that case it would not work together as Qlikview does not support group charts.

You know what I mean. any ways thank again.

Re: Combo Chart

saumyashah90 — Thu, 28 Nov 2013 12:21:02 GMT

You Have Option for that, After you Create a chart,

You can convert it into a report and get it in pdf format