Calendar: When selecting range, allow excluded values to be selected too
In Vizlib Calendar, when a range is selected, Vizlib does not select all of the dates in that range - it only selects those dates which are Possible (white) in that range, while ignoring gray (excluded) values. My request is to allow excluded dates to be selected as well, as a new option and without changing the default behavior.
A simple use case where this is very relevant:
A user selects region = North America. Then, the date range Jan 1st 2019 through Dec 31st 2019 is selected. Vizlib Calendar selects the 200 possible values - dates in which at least one sale happened in North America.
Our user now removes the Region = North America selection. In this context, the user expects to see all of the company sales for 2019, but instead, they will see partial sales - on sales on the 200 days in which at least one sale happened in North America. Days in which products were sold elsewhere (but not in North America) will be excluded because when we selected a range in our calendar, only the Possible values at the time were selected.
The desired behavior in this use case is for the entire date range between Jan 1st 2019 and Dec 31st to be selected, so that when other selections are modified, we will still see data for the entire (relevant) portion of 2019. This is equivalent to filtering the Date field using the expression >=Jan-01-2019<=Dec-31-2019, and as such it is consistent with how Qlik actually filters when you type in a range - it's just a different way to approach the same filter. As mentioned above, I don't think this should replace the default - I am hoping this can be added as an option to be enabled where needed.
2 people like this idea