Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Date field and I want to create a Bookmark and apply that Bookmark on the sheet.
I have Date field and I want to do >=Min(Date) and apply this Bookmark. When I create this Bookmark then the filter shows me "Date 100 of 102" because 100 values are selected and 2 are excluded based on this condition. But I want to show the "Date >=01.01.2022" So, filter must show what is the minimum date selected by default and minimum date to onward the dates are selected.
How to do it ?
Thanks
I'm not sure if there are sufficient ways to get this kind of view. Here a bit background - within Qlik there is no real >= <= or any kind of expression-searches in a selection else only resolved TRUE/FALSE flag-values against the dimension-values. Therefore it are always n possible/excluded values of all existing field-values.
Until a certain number of selected values the filter shows these values like they are and applies above of the threshold a smart shortcut of the selection - which means displaying that there are active selection but not cluttering the surface with too much (not really helpful) information.
The mentioned threshold could be adjusted within the user-settings - which means it is a global setting and related to certain applications or dimensions. Within functions like getfieldselections() this threshold could be overwritten with the third parameter - you may a bit playing with it to see what happens - and it may a starting point for the workaround to create own objects/views to display the needed selection state.