Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date comparison in set analysis

I am looking to compare 2 date fields using set analysis. 

Date1 <= Date2 + 29 

In this example I am trying to make sure that Date1 is less than or equal to Date2 + 29 days.

My current expression is:

COUNT({<Field1={A], Field2={B} >} Products)

Now I just need to incorporate the date comparison into the above expression.

Thanks!

6 Replies
MayilVahanan

HI,

     Try like this

     COUNT({<Field1={A}, Field2={B} ,Date1 = {'<=$(=Date(Max(Date2)+29)))'}>} Products)

     Hope there is link between Date1 and Date2 fields.

     Hope it helps..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

I gave this a try but haven't been able to get it to work yet. 

MayilVahanan

HI,

     Can you post a sample..Did you check the report, is there any link between date1 and date2..

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

In which place you are going to use this expression?

Not applicable
Author

Here is my example.

MayilVahanan

HI,

     Use like this

     COUNT({<AssessmentID = {"=A2000>=timestamp(A1600+29)"} >} AssessmentID)

     Hope it helps.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.