topic Count if time difference <= 30 'mm' in QlikView

Count if time difference <= 30 'mm'

Wed, 13 Mar 2013 16:32:45 GMT

Hello,

I am calculating the time difference using this expression =INTERVAL(InitialEncounterWithDoctorDateTime-ArrivalDateTime,'mm') . Calculation works great!

In the next column, I need an expression that will count if the time difference is <=30 and another column to count when it is >30.

I've tried this expression, but it doesn't work...

COUNT(IF(INTERVAL(InitialEncounterWithDoctorDateTime-ArrivalDateTime <=30, 'mm'),(VisitGUID

)))

Any help is appreciated!

Re: Count if time difference <= 30 'mm'

eddysanchez — Wed, 13 Mar 2013 16:48:55 GMT

the count always show 1

Maybe you need:

IF(INTERVAL(InitialEncounterWithDoctorDateTime-ArrivalDateTime <=30, 'mm'),'-30','+30')

Re: Count if time difference <= 30 'mm'

rwunderlich — Thu, 14 Mar 2013 01:26:57 GMT

I think your syntax is

COUNT(

IF(

INTERVAL(InitialEncounterWithDoctorDateTime-ArrivalDateTime, 'mm')<=30,

VisitGUID

)

I think you can also do

count(if (ArrivalToProv <=30, 1)

-Rob