Data presentation as per selection

Anku — Wed, 20 Sep 2023 18:00:57 GMT

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!

Re: Data presentation as per selection

Anku — Sat, 23 Sep 2023 03:38:31 GMT

Anyone?

anat — Sat, 23 Sep 2023 09:57:10 GMT

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)