Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
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)

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.