If statement to Set Analysis

Fri, 12 Apr 2013 14:03:46 GMT

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

Re: If statement to Set Analysis

ToniKautto — Fri, 12 Apr 2013 19:25:53 GMT

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.

topic Re: If statement to Set Analysis in QlikView

If statement to Set Analysis

Re: If statement to Set Analysis