topic Re: date comparison in set analysis in QlikView

date comparison in set analysis

Tue, 24 Jul 2012 14:26:15 GMT

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!

MayilVahanan — Tue, 24 Jul 2012 14:29:34 GMT

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

Tue, 24 Jul 2012 15:54:01 GMT

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

MayilVahanan — Tue, 24 Jul 2012 16:17:01 GMT

HI,

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

CELAMBARASAN — Tue, 24 Jul 2012 16:53:00 GMT

In which place you are going to use this expression?

Tue, 24 Jul 2012 17:08:24 GMT

Here is my example.

MayilVahanan — Tue, 24 Jul 2012 17:19:46 GMT

HI,

Use like this

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

Hope it helps.