topic if statement into set analysis in QlikView

if statement into set analysis

Thu, 08 May 2014 05:52:55 GMT

i am using this if statement in straight table expression please help me to convert this in set analysis

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

SergeyMak — Thu, 08 May 2014 06:12:00 GMT

In your case I would add if(SHIFTSTARTTIME<IN1 and time((IN1-SHIFTSTARTTIME),'hh:mm:ss')<'00:10:00','Yes','No') AS YourDimension in the load script

and then just use it as dimension.

I don't see how you can convert it to set analysis, just because you don't use aggregation functions like sum, count etc. in this expression

SunilChauhan — Thu, 08 May 2014 06:17:45 GMT

Only({<SHIFTSTARTTIME={"<$(=IN1)"}, IN1-SHIFT={'<00:10:00'}>} 'Yes') +

same this expression only change 'Yes' to 'No'

hope this helps

Thu, 08 May 2014 07:24:33 GMT

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

Thu, 08 May 2014 07:25:19 GMT

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

how will i show it

SunilChauhan — Thu, 08 May 2014 08:14:27 GMT

count({<shiftstarttime={<$(=only(in1))}>employee)