Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anku
Creator
Creator

Data presentation as per selection

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! 

Labels (1)
1 Solution

Accepted Solutions
anat
Master
Master

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)

View solution in original post

2 Replies
Anku
Creator
Creator
Author

Anyone? 

anat
Master
Master

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)