Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Need help with stacked bar charts

Hi all new to qilkview, I am trying to create a stacked bargraph using two calculate as the values for the bar, the graph will be organized by for example what fruit it is say apples or oranges ect. The calculated fields will be the amount of apples received and the amounts of  apples not received.  This will be done for each fruit. I am using mysql as the data is housed in multiple different databases each requiring a different connection. Does anyone have a solution to this problem? I have seen many stacked bar graphs but not ones that do the stacking correctly. If I try and use the stacked option in style it will stack all the fields together regardless of what fruit it is. I want to create something similar to the graph below. I can pull all the values from the databases successfully but getting the calculated values to stack correctly is my issue. 

 

 

 

 

stackedbarchart_img1 (1).png

1 Reply
Highlighted
Digital Support
Digital Support

So I believe to get what you want will require some tweaks to the data model side of things, but unfortunately I am not a good resource to try to help you with that.  About the best I have is the following link to try to give you some guidance, but maybe this will job someone else's mind to be able to come up with some further info that may help.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Loading_data.ht...

You might find something in the Design Blog area too:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Just not sure what you need there, so was not able to give you any direct posts, sorry.  Someone else may have some other ideas, but I think the only way is going to be to get the data model setup such that you can do what you want, but I am not sure how to do it.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.