Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
stmaru08
Contributor
Contributor

Filter ignoring date ranges where there is no data avaliable

Hi,

When i choose for example a date range on a master calendar from 01-may to 01-july, and then apply a filter on top of this, the filter then edits the date range in the dashboard to show data for only the month of may as there is no data in June/July for the required filter.

 

However, i need the may-july date range to remain selected in the master calendar when i apply the filter.

 

Is there a way to do this? 

I am using the current set analysis for the master calendar:

(max([Master_Calendar.Date])

Thanks

1 Reply
StarinieriG
Partner - Specialist
Partner - Specialist

Hi,

try to use:

 

max({1}[Master_Calendar.Date])