Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

Set Analysis: DateField1 <= DateField2

Hi guys,

 

In set analysis, I'm trying to do DateField1<=DateField2 by using:

Count({<DateField1={"<=DateField2"}>}Id)

 

But it's not working. It's only giving 0. 

Any idea how should I write this function? Thank you in advance!

1 Solution

Accepted Solutions
sunny_talwar

Or try this

Count({<Id = {"=DateField1 <= DateField2"}>} Id)

View solution in original post

2 Replies
Anil_Babu_Samineni

Try this?
Count({<DateField1={"=Datefield1<=DateField2"}>}Id)
Or
Count(if(DateField1<=DateField2, Id))
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

Or try this

Count({<Id = {"=DateField1 <= DateField2"}>} Id)