topic Re: Set Analysis for "IF" Statement in QlikView

Set Analysis for "IF" Statement

markgraham123 — Fri, 11 Sep 2015 17:54:26 GMT

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 — Sat, 12 Sep 2015 11:18:01 GMT

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

markgraham123 — Tue, 15 Sep 2015 18:31:16 GMT

Thanq verymuch Gysbert.

Learnt new thing