Data presentation as per selection

[Anku]

Hi all,

I have a table in Data model which has "ID" & "Date".

Column "ID" has unique values however, Column "Date" has Dates as well as Blanks.

I want to create a table in frontend which must show only future dates, and Blanks also, as per "Date" selection in a Dropdown (in frontend).

I have added a column;

Flag = IF(Len(Trim(Date))=0 or Date > 20-Sept-2023,1,0)    <<<<<<--Static date for example

I am getting the desired output but I have restrain the data to shown only records after 20-Sept-2023.

I am figuring out a way where I can change the dates in front and table must update accordingly.

Please share your thoughts. Thanks! 

[Anku]

Anyone? 

[anat · Accepted solution]

in load script create flag for data blank values
if(len(date)=0,1,0) as dateflag

frontend create a variable vmaxdate=max(date)

sum({<date=,date = {">=$(=vmaxdate)"}>+<dateflag={1}>} sal)