topic Stacked Bar-Chart Problem in QlikView

Stacked Bar-Chart Problem

markmm — Wed, 08 Feb 2012 09:33:02 GMT

Hi Guys

Is there a possibility to build the chart like the attached (Excel) one? I had no success....

Thanks for your help

Stacked Bar-Chart Problem

kaushiknsolanki — Wed, 08 Feb 2012 09:39:27 GMT

Hi,

All you have to do is create a bar chart with one dimension and two expression.

Now go to properties -> Stype -> Here select Subtype as stacked.

Regards,

Kaushik Solanki

Re: Stacked Bar-Chart Problem

Sokkorn — Wed, 08 Feb 2012 09:42:56 GMT

Hi,

See the sample attached file.

Hope this help.

Regards,

Sokkorn Cheav

Re: Stacked Bar-Chart Problem

markmm — Wed, 08 Feb 2012 09:52:39 GMT

Hi,

The problem is that i want to have a stacked bar for each dimension value and each bar must be 100% on the y-axis (see attached excel example)

Thanks

Stacked Bar-Chart Problem

kaushiknsolanki — Wed, 08 Feb 2012 10:18:23 GMT

Hi,

Did you check the example given by Sokkorn.

Its the same as what you have shown in excel file.

Regards,

Kaushik Solanki

Stacked Bar-Chart Problem

markmm — Thu, 09 Feb 2012 20:00:56 GMT

Unfortunately it's not the same. Compare the y-axis. In my example the y-axis is in % and each bar is 100%. Additionally the values in the graphic are in number and not in %

Regards, Mark

Re: Stacked Bar-Chart Problem

Anonymous — Thu, 08 Mar 2012 09:55:42 GMT

apply the same denominator to both expressions

SUM(vollständig)/sum(unvollständig+vollständig)

SUM(unvollständig)/sum(unvollständig+vollständig)

Re: Stacked Bar-Chart Problem

jagan — Thu, 08 Mar 2012 11:35:26 GMT

Hi,

Please check the attachment. hope it helps you.

Regards,

Jagan.

Re: Stacked Bar-Chart Problem

matt_crowther — Thu, 08 Mar 2012 12:34:13 GMT

Getting the actual values in the bars instead of the percentages will be tricky as you can't assign a different value (the actual) to the datapoint (the percentage).

I'd look to perhaps use something like the below:

Basically creating a hybrid Trellis style chart with a shared axis. If you replicated the Excel chart exactly it could be confusing as your bars in some cases have higher numbers ('B' = 437) but smaller bars ('A' = 105) that's why I've shown the actuals in a traditional method.

This is a method that Tableau uses quite often to good effect.

All the best,

Matt - Visual Analytics Ltd

Qlikview Design Blog: http://QVDesign.wordpress.com

Twitter: @QlikviewBI

Stacked Bar-Chart Problem

Wed, 28 Mar 2012 12:08:24 GMT

Hello!

Is there any way to keep the actual values on the data without being in percentage?

Tks.