Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
markmm
Partner
Partner

Stacked Bar-Chart Problem

Hi Guys

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

Thanks for your help

9 Replies
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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Sokkorn
Master
Master

Hi,

See the sample attached file.

Hope this help.

Regards,

Sokkorn Cheav

markmm
Partner
Partner
Author

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   

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
markmm
Partner
Partner
Author

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

scully01
Contributor II
Contributor II

apply the same denominator to both expressions

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

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

jagan
MVP
MVP

Hi,

Please check the attachment.  hope it helps you.

Regards,

Jagan.

matt_crowther
Luminary Alumni
Luminary Alumni

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:

Side by Side.PNG

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

Not applicable

Hello!

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

Tks.