Exclude partial month from list box

Anonymous — Mon, 08 Apr 2024 09:55:33 GMT

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

Re: Exclude partial month from list box

marcus_sommer — Mon, 08 Apr 2024 13:33:16 GMT

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

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

topic Re: Exclude partial month from list box in QlikView

Exclude partial month from list box

Re: Exclude partial month from list box