topic How to filter bar chart properly even when 'Show All Values' has been checked? in QlikView

How to filter bar chart properly even when 'Show All Values' has been checked?

mrichman — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have a bar chart and it is show all months, also the ones without data. However, I still would like to filter my bar chart - do you guys know any solution?

Example:

If I have a range of month July - Dec, where August has no data. When I select July-September, I still want to see August but the other months should be hidden.

Thanks in advance!

Re: How to filter bar chart properly even when 'Show All Values' has been checked?

Arthur_Fong — Fri, 16 Aug 2019 05:12:17 GMT

Hi,

What you need is a Master Calendar.

Refer qvw attached with your expected output shown in dashboard.

Thanks and regards,

Arthur Fong

Re: How to filter bar chart properly even when 'Show All Values' has been checked?

Brett_Bleess — Wed, 28 Aug 2019 20:34:12 GMT

Miguel, here is a Design Blog post to go along with Arthur's idea that goes into some further details on the Master Calendar concept, figured it might help a bit further. If Arthur's post and app helped you get things working, be sure to give him credit by using the Accept as Solution button to do that.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

Regards,
Brett