topic Re: Combine 2 stacked bar charts having same dimensions in QlikView

Combine 2 stacked bar charts having same dimensions

supriyabiware — Wed, 15 Aug 2018 09:13:06 GMT

Hello all,

i have 2 stacked charts exactly same looking, but the values are different since one is with respect to filter (WSTG) and the other one is excluding the filter (WSTG) - i have done this is expressions with set analysis.

i have to combine both the dimensions and show it as single chart (with same scrollbar) , side by side . is this possible?

Thanks,

Supriya.

Re: Combine 2 stacked bar charts having same dimensions

BalaBhaskar_Qlik — Wed, 15 Aug 2018 09:37:38 GMT

May be it's bit tricky.

But, Combine both dimensions as Single in a list box and bar chart.

Comparisons like this are normally done by simply selecting the two values you want to compare in the SAME list box, not in two different list boxes, it's how it would normally be done, think so.

Re: Combine 2 stacked bar charts having same dimensions

supriyabiware — Wed, 15 Aug 2018 09:49:41 GMT

i just want to remove the extra dimension from middle and have common dimension for both chart.

i tried using butterfly option, but scroll is a problem

Re: Combine 2 stacked bar charts having same dimensions

supriyabiware — Thu, 16 Aug 2018 09:59:35 GMT

hello all,

anyone having any ideas on this one?

i just have to combine two charts. any workaround would also do.

Thanks,

Supriya.

Re: Combine 2 stacked bar charts having same dimensions

Anil_Babu_Samineni — Thu, 16 Aug 2018 13:21:28 GMT

Would you able to share application to check?

Re: Combine 2 stacked bar charts having same dimensions

Or — Thu, 16 Aug 2018 13:43:39 GMT

I'm not aware of any way to control the scrolling of two charts from one scroll bar.

Best workaround I can think of is to add another dimension so you have a two-bar grouped chart, each bar stacked, and then flip one of the bars into the negative (multiply by -1) so they go in opposite directions. They will be offset since they're grouped, but at least they'll be next to each other and hopefully it'll be clear which one you want.

If you use that approach, you will have to combine the two expressions into one and selectively display the result for the second dimension. Otherwise, I don't think you can make QV use the expressions for grouping and the dimension for stacking.

Re: Combine 2 stacked bar charts having same dimensions

supriyabiware — Fri, 17 Aug 2018 09:53:31 GMT

hi Shoham,

Thanks for the reply.

But i already tried the Butterfly (-1 and joining) but scrolling is a problem, and if i make -1 only it looks not so good with dimensions in left.(can i have gap in between both?) and some +ve values are coming at the left

Thanks,

Supriya

Re: Combine 2 stacked bar charts having same dimensions

supriyabiware — Fri, 17 Aug 2018 09:54:39 GMT

unfortunately not possble. you can take any 2 stack charts (with same dimensons but different values on expression).

Re: Combine 2 stacked bar charts having same dimensions

Anil_Babu_Samineni — Sat, 18 Aug 2018 13:48:34 GMT

If you do and share that QVW, Will help better.

Re: Combine 2 stacked bar charts having same dimensions

supriyabiware — Thu, 23 Aug 2018 08:32:24 GMT

Hello marcowedel‌ , could you please help in this one?

I saw the solution you gave for following thread -- something similar solution would be great help.

stacked and grouped barchart in qlikview

Problem is i have too many dimension values on X axis and have to use a scroll bar.

Thanks,

Supriya

Re: Combine 2 stacked bar charts having same dimensions

MarcoWedel — Thu, 23 Aug 2018 22:23:04 GMT

HI,

you can activate the scrollbar option in the sample application of your linked thread like this:

hope this helps

regards

Marco

Re: Combine 2 stacked bar charts having same dimensions

supriyabiware — Tue, 11 Sep 2018 07:10:20 GMT

Thanks for the Reply it looks good now. but somehow i want to try keeping them seperate and scrolling.

Could you help me with any extensions or any other way out( eg. Macro) to scroll 2 charts at the same time?

Thanks,

Supriya.

Re: Combine 2 stacked bar charts having same dimensions

MarcoWedel — Wed, 12 Sep 2018 21:15:04 GMT

You want to combine your expressions into one single chart, yet you want to synchronously scroll to different charts?

I'm confused.

Re: Combine 2 stacked bar charts having same dimensions

Or — Thu, 13 Sep 2018 10:17:29 GMT

I think the top option was to make the charts scroll at the same time, and the potential workaround (since there's no way, afaik, to make two charts scroll together) was to somehow put all the information in one chart so there's a shared scroll bar.

Re: Combine 2 stacked bar charts having same dimensions

hemanth_T — Wed, 22 Apr 2020 03:11:27 GMT

Hi Marco/Anil,

@MarcoWedel @Anil_Babu_Samineni

Do we have similar Option in Qliksense, to have two different Stacked Measures on the same Bar graph side by side, so that, they are easy to compare. (The second measure is a subset of the 1st measure and have have same bar group and Dimension).

Thanks,

Hemanth