Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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!

Tags (2)
6 Replies

Re: date comparison in set analysis

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..

Not applicable

Re: date comparison in set analysis

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

Re: date comparison in set analysis

HI,

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

Re: date comparison in set analysis

In which place you are going to use this expression?

Not applicable

Re: date comparison in set analysis

Here is my example.

Re: date comparison in set analysis

HI,

     Use like this

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

     Hope it helps.

Community Browser