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.
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.
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.
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.