If statement to Set Analysis

[#1]

Hi all,

Could someone help me transform this if statement to set analysis instead please?

=if(isnull(min({$<Shift_Date={'$(vYesterday)'}>}ClockInOutTime)) and sum(OrderComplete_Flag)>0,vClockIn,

if(frac(num(Min({$<Shift_Date={'$(vYesterday)'}>}ClockInOutTime)))>num(time(vLateClockIn)),vClockIn,

          frac(num(Min({$<Shift_Date={'$(vYesterday)'}>}ClockInOutTime)))))

Thanks

[ToniKautto]

Set analysis is not really a replacement for IF statements, so it is a bit unclear what you are trying to accomplish in this case. What issue are you trying to resolve by altering the statement?

It is most often essential to have access to a sample QVW when evaluating an expression, since the dimensions of the chart and the data model are relevant considerations. also your expression has variable, which content is unclear without a sample application.

So please clarify what issue you have run into and what you are trying to accomplish, along with a sample appplicaiton and you will increase the possibility to get a quicker and morehelpful answer.