Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

show values based on condition

I  want to show Table with values if Date 2 is < Date 1..but I do not want to eliminate rows if Date2 is blank.

NameDate1Date2
ABC8/21/20208/24/2020
DEF8/22/2020 
HIJ8/23/20208/20/2020

Output would be 2nd and 3rd row from the table.

I tried below expression but it eliminates rows, if date 2 is blank as well.

if(Date2 < Date1, Name)

Labels (6)
1 Reply
Steven_Haught
Creator III
Creator III

You can try flipping your data there. Try this:

=If(Date1>Date2,Name)

Then un-check include null values.