Stacked Bar-Chart Problem

[markmm]

Hi Guys

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

Thanks for your help

[kaushiknsolanki]

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

[Sokkorn]

Hi,

See the sample attached file.

Hope this help.

Regards,

Sokkorn Cheav

[markmm]

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

[kaushiknsolanki]

Hi,

     Did you check the example given by Sokkorn.

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

Regards,

Kaushik Solanki   

[markmm]

Hi

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

[Anonymous]

apply the same denominator to both expressions

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

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

[jagan]

Hi,

Please check the attachment.  hope it helps you.

Regards,

Jagan.

[matt_crowther]

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

[#10]

Hello!

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

Tks.