I am trying to show percentages of multiple fields in a bar chart and since I had 8 fields to show in a single bar chart I am using valuelist() as my dimension and writing case statements in measure for each value mentioned in the valuelist()
I am able to achieve what is required in the bar graph but there is no interactivity between the bar chart and the other visualizations of the app.
Example: When I select the 'Category A' field mentioned in the label of the bar chart other charts and KPIs are not getting updated accordingly (which is expected I guess since I am hard coding the dimensions as labels).
Can anyone suggest a possible way to meet the requirement of bar graph and not to lose the basic functionality of qlik sense charts interactivity at the same time?
