topic Re: Comparing two fields in Set Analysis in QlikView

Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 05:41:51 GMT

Hello,

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

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

Regards,

Balraj

Re: Comparing two fields in Set Analysis

PrashantSangle — Mon, 29 Sep 2014 05:45:50 GMT

Hi,

Try this

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

Regards

Re: Comparing two fields in Set Analysis

sujeetsingh — Mon, 29 Sep 2014 05:46:53 GMT

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

Re: Comparing two fields in Set Analysis

anbu1984 — Mon, 29 Sep 2014 05:50:28 GMT

What is ShiftStartGraceTime? Field or Variable?

Re: Comparing two fields in Set Analysis

AbhijitBansode — Mon, 29 Sep 2014 05:51:19 GMT

If ShiftStartGraceTime is variable then reply by max dreamer will serve the purpose else below

Count ( { < _IN_TIME = {" > ShiftStartGraceTime "} > } DISTINCT %Date )

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 05:51:32 GMT

not working. Same result

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 05:55:07 GMT

Not Working

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 05:55:38 GMT

Both are two different fields, my dear

Re: Comparing two fields in Set Analysis

sagarkharpude — Mon, 29 Sep 2014 05:58:24 GMT

count(Distinct{<_IN_TIME={">$(=ShiftStartGraceTime)"}>} DISTINCT(%Date))

Re: Comparing two fields in Set Analysis

AbhijitBansode — Mon, 29 Sep 2014 05:58:56 GMT

please attach demo app with sample data.

Re: Comparing two fields in Set Analysis

anbu1984 — Mon, 29 Sep 2014 06:00:04 GMT

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

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

Re: Comparing two fields in Set Analysis

PrashantSangle — Mon, 29 Sep 2014 06:01:22 GMT

Hi,

What is format of _IN_TIME and ShiftStartGraceTime?

if possible share smaple apps?

Regards

Re: Comparing two fields in Set Analysis

lironbaram — Mon, 29 Sep 2014 06:06:12 GMT

what exactly are you looking to achieve in the formula

does the two fields are in the same tables?

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 06:13:10 GMT

Liron,

Both are in two different tables.

I have to count late comers using this formula.

Regards,

Balraj

Re: Comparing two fields in Set Analysis

lironbaram — Mon, 29 Sep 2014 06:23:20 GMT

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?

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 06:29:36 GMT

its Field

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 06:54:10 GMT

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

What is the error in this syntax?

Re: Comparing two fields in Set Analysis

PrashantSangle — Mon, 29 Sep 2014 07:03:12 GMT

Hi,

Is you and Abhay Singh Working on same project?

Check this thread

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

Regards

Re: Comparing two fields in Set Analysis

Anonymous — Mon, 29 Sep 2014 08:12:40 GMT

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

Re: Comparing two fields in Set Analysis

anbu1984 — Mon, 29 Sep 2014 09:36:45 GMT

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