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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exclude partial month from list box

Hi,

I'm trying to create a list box that excludes partial months. The partial month will always be newest data, and I want to keep it in the load for other purposes.

For example, the list box shouldn't show Apr-2024 if the latest data goes up to 8th April 2024.

Many thanks

 

Labels (2)
1 Reply
marcus_sommer

You may prepare such field within the calendar, maybe with something:

if(today() - ThresholdValue < monthstart(today()), MyDateField, null()) as MyDateField2