I have a bar chart in which the horizontal axis is the calendar date, and under each date is a group of measures, such as Gross Sales (Bar A), Discounts (Bar B), Net Sales (Bar C). Hence for each date, there will be 3 bars for every date in bar chart.
Is there any way I can create a filter pane to filter out certain measures when viewing the bar chart, eg to display only Bar A (the Gross Sales) for all the dates, without displaying the other 2 bars?
So far the filter panes I have created work on dimensions and fields, but there seems to be no options to filter/hide measures as a bar in the charts. I am currently using Qlik Sense Enterprise.
Hello @Jason_KKA, the fastest way I can think about to do that would be to create as many bar charts as you need to visualize inside a container, in order for you to switch between them as needed. Have a look at the attached example 😊
If the issue is solved please mark the answer with Accept as Solution.
Hello @Jason_KKA, the fastest way I can think about to do that would be to create as many bar charts as you need to visualize inside a container, in order for you to switch between them as needed. Have a look at the attached example 😊
If the issue is solved please mark the answer with Accept as Solution.
Thanks Andrea, I have not explored using containers before, and this is an amazing roundabout to achieve a similar outcome (though it is not exactly a filter pane). Thanks a million 😀!
However, I couldn't apply your method on my app as my measures are mostly calculated fields, created as master items (some of which are moving averages involving set expressions). As I cannot load them as fields at data load editor level, I am not able to add them into the filter panes like you did in the sample.
.png "Former Employee"){kind=icon}
