Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mrichman
Contributor II

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

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. 

QlikCommunity-15-08-2019.PNG

QlikCommunity-15-08-2019 part 2.PNG

Thanks in advance!

1 Solution

Accepted Solutions
Partner
Partner

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

Hi,

What you need is a Master Calendar.

Refer qvw attached with your expected output shown in dashboard.

MC.PNG

Thanks and regards,

Arthur Fong

View solution in original post

2 Replies
Partner
Partner

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

Hi,

What you need is a Master Calendar.

Refer qvw attached with your expected output shown in dashboard.

MC.PNG

Thanks and regards,

Arthur Fong

View solution in original post

Support
Support

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

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.