Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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)
Anyone?
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)