topic Re: Show only dates 120 days out from today in App Development

Show only dates 120 days out from today

bruce_sorge — Mon, 25 Nov 2024 17:26:39 GMT

Greetings folks,

I have a table (vizlib) where one of the columns need to show only records 120 days from today. I have Googled this for a couple days now and I found two scripts that kind of work in my set expression:

if([Agency Deadline]>=today() or [Agency Deadline]<=today()+120,[Agency Deadline]) ( {<[Agency Deadline]={">=$(=Date((Max(Date)+120)))"}>} [Agency Deadline] )

The problem is I am still getting dates greater than 120 days. My date field is a timestamp if that helps. I am converting it from a timestamp to a date field in the Load script:

Date([Baseline Due Date],'MM/DD/YYYY') AS [Agency Deadline]

Thanks in advance.

Re: Show only dates 120 days out from today

Frank_S — Mon, 25 Nov 2024 18:47:02 GMT

Try using a Qlik Native table object to check if it produces the expect results or the same unexpected results.

Also check if there are any always one selected values in your data fields that might be skewing the results incorrectly.

Kind regards.,,

Re: Show only dates 120 days out from today

bruce_sorge — Mon, 02 Dec 2024 12:19:51 GMT

Thanks for the answer but that didn't work. Exactly same result. I ended up ditching the vizlib table and went with a native qlik table and entered this expression into the expression editor for the date column and it worked.

=If(Date([Agency Deadline],'MM/DD/YYYY') <= AddMonths(Today(), 3), [Agency Deadline])

And that is working fine.