Set Analysis for "IF" Statement

[markgraham123]

Hi all,

I was trying to do the following statements using Set analysis instead of If.

Can someone help me in getting the same expressions using Set analysis.

If(RangeStdev( [V1],  [V2],  [V3])<=5, 'Good', 'Alert')

If( IsNull([V1]) or [V1]<=1 or IsNull([V2]) or [V2]<=1 or IsNull([V3]) or [V3]<=1, 'Threat', 'No Threat')

[Gysbert_Wassenaar · Accepted solution]

Set analysis can not branch. It can only filter. Your if statements do branch so you cannot replace them with set analysis expressions.

[markgraham123]

Thanq verymuch Gysbert.

Learnt new thing