topic Re: from if to set analysis statement in QlikView

from if to set analysis statement

Thu, 08 May 2014 06:22:17 GMT

i have used this statement in straight table please , help me to convert this in set analysis

=if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')>='00:10:00' and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:20:00','Yes','No')

SHIFTSTARTTIME is the starting time of a shift of a employee

IN1 is the in-time of a employee

by this statement i have successfully showed in front of employees name that if he is late by more than 10 min but less than 20 min than show yes in that column

please help me to convert this statement into set analysis

Re: from if to set analysis statement

tresB — Thu, 08 May 2014 06:33:53 GMT

Set analysis is used where you directly can compare with a field. But here in your expression, you have portion like: time((IN1-SHIFTSTARTTIME),'hh:mm:ss')>='00:10:00' which is not really comparison with a single field. Therefore, the entire expression could not be converted to set analysis; it would be mix of set and if I guess.

Re: from if to set analysis statement

its_anandrjs — Thu, 08 May 2014 06:40:01 GMT

For your If expression to the SET expression use variables because there is multiple calculations and it is very hard for converting to SET may be find the combination of If and SET

Let vTimDiff = time((IN1-SHIFTSTARTTIME),'hh:mm:ss');

for your expression

=if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')>='00:10:00' and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:20:00','Yes','No')

Re: from if to set analysis statement

SergeyMak — Thu, 08 May 2014 07:00:18 GMT

navneet_nav

Probably it's not good idea to ask same questions. I think you you can just edit previous one

if statement into set analysis

Re: from if to set analysis statement

Thu, 08 May 2014 07:23:34 GMT

how to put greater than symbol ">" in set analysis

count({<shiftstarttime={'<'(=in1) }>} Employee)

please convert above in correct set analysis

i want to show if (shiftstarttime<in1, count(employee)) in set

Re: from if to set analysis statement

rajat2392 — Thu, 08 May 2014 07:25:24 GMT

count({<shiftstarttime={"<$(=in1)" }>} Employee)

Re: from if to set analysis statement

tresB — Thu, 08 May 2014 07:26:10 GMT

in1 is another field right? Then try:

=count({<shiftstarttime={"=shiftstarttime>in1" }>} Employee)

Re: from if to set analysis statement

its_anandrjs — Thu, 08 May 2014 07:26:24 GMT

Write like

count({<shiftstarttime={'<$(=in1)' }>} Employee)

Re: from if to set analysis statement

Thu, 08 May 2014 07:27:45 GMT

thanks