Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
profilejamesbond

Min(Date) in Bookmark

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

Labels (2)
1 Reply
marcus_sommer

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.