Comparing two fields in Set Analysis

[Anonymous]

Hello,

Can anybody tell what is the syntax error in this expression:

=count({<_IN_TIME={'>ShiftStartGraceTime'}>} DISTINCT(%Date))

Regards,

Balraj

[anbu1984]

Do you want to compare _IN_TIME and ShiftStartGraceTime in the same row? Then try this

=Count( Distinct If(_IN_TIME > ShiftStartGraceTime, %Date))

[PrashantSangle]

Hi,

What is format of _IN_TIME and ShiftStartGraceTime?

if possible share smaple apps?

Regards

[lironbaram]

what exactly are you looking  to achieve in the formula

does the two fields are in the same tables?

[Anonymous]

Liron,

Both are in two different tables.

I have to count late comers using this formula.

Regards,

Balraj

[lironbaram]

hi

set analysis won't work as it replaces selections not if statemnet

assuming that for each _in_time record there is only one shiftgracetime

then try to use

Count (DISTINCT if( _IN_TIME >ShiftStartGraceTime, %Date ))

how the two tables are connected?

[Anonymous]

its Field

[Anonymous]

Count( Distinct If(_IN_TIME > ShiftStartGraceTime and _AttendanceStatus='P' ,'POW'  , %Date))

What is the error in this syntax?

[PrashantSangle]

Hi,

Is you and Abhay Singh Working on same project?

Check this thread

http://community.qlik.com/thread/135313

Regards

[Anonymous]

Yes,

But still we have not got the solution, I have checked the Time Format twice but not able to use SET Analysis properly..

=Count( Distinct If(num(_IN_TIME) > num(ShiftStartGraceTime) and _AttendanceStatus='P','POW','MIS' , %Date))

Tried If as well but not working

[anbu1984]

=Count( Distinct If(num(_IN_TIME) > num(ShiftStartGraceTime) and Match(_AttendanceStatus,'P','POW','MIS') , %Date))