topic Re: Stacked Bar Chart with Line in QlikView

Stacked Bar Chart with Line

manojkulkarni — Fri, 15 Jul 2016 07:06:43 GMT

Hi Friends,

I have one requirement, in which i am displaying stacked bar chart for 2 dimensions. Now user wants to add Line to show the trend of same data. How should we achieve ?

Attached the expected output

Re: Stacked Bar Chart with Line

PrashantSangle — Fri, 15 Jul 2016 07:12:19 GMT

USe combo chart..

Regards

Re: Stacked Bar Chart with Line

PrashantSangle — Fri, 15 Jul 2016 07:15:45 GMT

Hi,

In expression tab add 1 expression > Select Display Option > Bar

In expression tab add 2 expression > Select Display Option > Bar

In Style > SubType > select stack.

In expression tab add 3 expression > Select Display Option > Line

Regards

Re: Stacked Bar Chart with Line

manojkulkarni — Fri, 15 Jul 2016 08:33:24 GMT

I have 2 dimensions & single expression to be used

Re: Stacked Bar Chart with Line

manojkulkarni — Fri, 15 Jul 2016 08:36:21 GMT

Below is the sample data. Using Month & Priority as dimension & Value in expression. Priority values are not fixed, so cann't hard code the expression as well.

Month	Priority
Feb-16	Low	28
Mar-16	High	1
Mar-16	Low	33
Apr-16	Low	16
May-16	Low	16
Jun-16	Medium	1
Jun-16	Low	18
Jul-16	Low	7

Re: Stacked Bar Chart with Line

Anil_Babu_Samineni — Fri, 15 Jul 2016 08:40:53 GMT

Manoj, Can i know what is your Dimensions and can you please share me the Sample App which demonstrates to understand the problem. Here, The best way to achieve is Combo Chart only. If your dimensions are Month and Priority what is the expression you are trying to show

What exactly your Req?

Re: Stacked Bar Chart with Line

manojkulkarni — Fri, 15 Jul 2016 09:00:25 GMT

My Dimensions will be MonthYear & Priority, expression will be sum of Values.

Would like to see Stacked bar chart per month and along with the bars there should be a line to show the trend. Trend line is nothing but the total value of the corresponding month.

Re: Stacked Bar Chart with Line

danansell42 — Fri, 15 Jul 2016 09:01:36 GMT

Hi Manoj

is the attached what you are looking for?

Dan

Re: Stacked Bar Chart with Line

Fri, 15 Jul 2016 09:04:21 GMT

Hi Manoj

You need to create 3 bar expressions for priorities using set analysis and one line expression for total value.

See attached for details

Regards, VJ

Re: Stacked Bar Chart with Line

rubenmarin — Fri, 15 Jul 2016 09:07:13 GMT

Hi Manoj, one option is overlapping two charts:

- One for stacked bars in upper layer to make selections. Transparent background (in color tab). Using CTRL+MAYS to fix the legend area so it doesnt' moves.

- The 2nd with the trend line in a lower layer, removing axes, legends and everything else and place it where it fits with the chart area of the upper chart.

It's supposed that two charts will have the same axis values, if not you'll need to fix them using the max and min in the axis tab to keep the same range in both charts.

Re: Stacked Bar Chart with Line

Anil_Babu_Samineni — Fri, 15 Jul 2016 09:09:06 GMT

I taken the Daniel Chart. Here, i take 2 Dim

Like this

Re: Stacked Bar Chart with Line

manojkulkarni — Fri, 15 Jul 2016 09:09:37 GMT

Thanks for your reply. As mentioned, priority data may change or new values might get added. Then this will not work

Re: Stacked Bar Chart with Line

manojkulkarni — Fri, 15 Jul 2016 09:12:57 GMT

Thanks Ruben, This is good idea but is workaround. If something possible in single chart itself then it would be great

Re: Stacked Bar Chart with Line

bharani8 — Thu, 24 Aug 2017 11:58:30 GMT

Can we get the same logic in 100% Stacked combo chart ? Below is the example.. Now i need to drew line at 75% & 90%..