topic stacked bar chart with one dimension in QlikView

stacked bar chart with one dimension

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

Hi everyone,

i had a requirement like need to display a bar chart in stacked format with one dimension like pyr_typ and expression like sum(rx_volume).

Is it possible to show bar chart in stacked format with one dimension.

please find the attached screenshot for your reference.

Please find also the attached qvw in which i tried to change Chart Properties > Style > Subtype > Stacked?

but it is not working

Thanks

Anu

Re: stacked bar chart with one dimension

hector_munoz — Fri, 23 Jun 2017 09:44:33 GMT

Hi Anu,

Have you tried Chart Properties > Style > Subtype > Stacked?

Regards,

Re: stacked bar chart with one dimension

Anonymous — Fri, 23 Jun 2017 09:45:26 GMT

Yes,

Go to the bar graph. Open properties->style. When you get there, you can choose stacked. It will be controlled by the expressions and not dimensions

Re: stacked bar chart with one dimension

MK_QSL — Fri, 23 Jun 2017 09:52:25 GMT

You can't create a Stacked Bar Chart with One Dimension and One Expression.

You need either Two Dimensions or Two Expressions.

There is a workaround.

Check below link.

Horizontal stacked bar chart with one dimension

Re: stacked bar chart with one dimension

anukumari — Fri, 23 Jun 2017 10:18:03 GMT

Hi Manish,

Thanks for the reply. Issue was resolved by following the link what you have sent.

But in the bar chart is there is any possibility to show the legend inside the chart like unk - 4.99%,mcare - 41.44%

please find the screen shot

Re: stacked bar chart with one dimension

MK_QSL — Fri, 23 Jun 2017 10:44:31 GMT

Yes..

Dimension

1) =''

This is Calculated Dimension

2) Country

Change with your dimension

Expression

Dual(Num(Sum(Sales)/SUM(Total Sales),'#0.00%')&Chr(10)&Country,Sum(Sales)/SUM(Total Sales))

Change according to your need.

Sum(Sales)/SUM(Total Sales) with your expression

Country with your dimension

Tick Values on Data Point

Go to Presentation Tab and Untick Show Legend

Updated after Avinash's reply.

go to presentation tab

Tick plot value inside the segments

Re: stacked bar chart with one dimension

avinashelite — Fri, 23 Jun 2017 11:00:59 GMT

Try like this

go to presentation tab plot value inside the segments

Re: stacked bar chart with one dimension

anukumari — Fri, 23 Jun 2017 11:21:06 GMT

hi manish,

i have tried the same but it is not working.

Please find the attachment.

Thanks

Anu

Re: stacked bar chart with one dimension

MK_QSL — Fri, 23 Jun 2017 12:00:09 GMT

Try to create the same chart again. Delete the current chart and recreate it.

Re: stacked bar chart with one dimension

MK_QSL — Fri, 23 Jun 2017 12:02:05 GMT

Because you have used Relative option here.

Untick Relative

Use below expression

Dual(Num(Sum(RX_VOLUME)/Sum(Total RX_VOLUME),'#0.00%')&'-'&PYR_TYP,Sum(RX_VOLUME))

Tick Values on Data Point

Go to Presentation Tab

Untick Show Legend

Tick plot value inside the segments