if statement into set analysis

[#1]

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]

Hi

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]

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

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

hope this helps

[#4]

if

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

[#5]

if

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

how will i show it

[SunilChauhan]

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