topic Re: Overlap Bars on a chart in QlikView

Overlap Bars on a chart

Tue, 20 Nov 2012 03:18:41 GMT

Hi I'm trying to force bars on a chart to overlap. This requires the front bar to be thinner that theone behind.

This is what I have so far but can't get the bars to overlap fully.

This is what I was hoping for.

Appreciate any help.

Thanks

Rob

Re: Overlap Bars on a chart

Tue, 20 Nov 2012 05:59:53 GMT

Hi,

You can go to the Chart Properties - Style tab and select subtype as Stacked.

Please find attachment.

Hope this helps.

Regards,

-Khaled

Re: Overlap Bars on a chart

jonathandienst — Tue, 20 Nov 2012 06:12:16 GMT

I dont think that you can get to that chart style directly. It may be possible by overlaying the red bar chart on top of the blue one - but its tricky to get such overlapped objects to behave nicely when the user interacts with them.

Hope that helps

Jonathan

Re: Overlap Bars on a chart

Anonymous — Tue, 20 Nov 2012 06:16:38 GMT

The closest thing I can think of is the bullet chart extension.

See this example document under the Bullet Chart tab:

http://eu.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Extension%20Examples.qvw&host=Demo11&anonymous=true

This is a bullet chart extension thread with an extension available for download:

http://community.qlik.com/thread/52956

Re: Overlap Bars on a chart

Tue, 20 Nov 2012 21:17:08 GMT

Hi Jonathan, I was trying overlapping two charts but it does get messy.

Re: Overlap Bars on a chart

Tue, 20 Nov 2012 21:19:27 GMT

Johannes, the bullet chart looks an interesting concept and may help illustrate the results better than I was hoping.

How do I get the extention?

Thanks

Rob

Re: Overlap Bars on a chart

Wed, 05 Dec 2012 15:36:54 GMT

Hi Rob, did you figure this one out?

I'm having the exact same problem. I've got one bar chart object overlapping another bar chart object, which works fine until you select a dimension with more than ~30 values, at which point the two charts stop lining up... seems a shame that such basic Excel functionality isn't present in Qlikview!

Re: Overlap Bars on a chart

Mon, 10 Dec 2012 21:37:40 GMT

No I couldn't get it to work! may be something we suggest to Qlikview as one of their basic features.

Thanks

Rob

Re: Overlap Bars on a chart

Fri, 12 Jul 2013 14:17:49 GMT

Hi,

On the propertys chart, you can use negatives numbers on the presentation tab (like -4, for example).

Tks,

André

Re: Overlap Bars on a chart

Fri, 28 Mar 2014 19:59:56 GMT

I'll second that request!

Re: Overlap Bars on a chart

Fri, 28 Mar 2014 21:57:04 GMT

What do you think to use 3d graph by setting the transparency color? There will be various widths but both (red and blue) bars are visible.
Another idea is to use the post for the first expression and the symbol for the other.
I know this is not exactly what you expect and the only workaround ...

regards

Darek

Re: Overlap Bars on a chart

Mon, 10 Nov 2014 13:17:29 GMT

Did you solved this issue?

I m also having same type of requirement .

Re: Overlap Bars on a chart

Mon, 10 Nov 2014 17:31:46 GMT

No I'm afraid not. Sorry

Re: Overlap Bars on a chart

raviityou — Tue, 11 Nov 2014 08:59:30 GMT

hi,

try this hope it will help u

select style

Re: Overlap Bars on a chart

Tue, 27 Jan 2015 15:28:03 GMT

Hi Johannes,

How I can run extension in qlikview

Thanks

Nasim

Re: Overlap Bars on a chart

wade12 — Thu, 27 Sep 2018 09:00:37 GMT

i have created a seagull chart for you (app attached).

hope this helps.

best wishes.

Re: Overlap Bars on a chart

deepika_gohil — Wed, 15 May 2019 06:06:32 GMT

Hey Rob,

Were you able to create this Overlap chart?
Actually I also have the same requirement and not able to do it.
Please suggest if you have done it