Discussion Board for collaboration related to Creating Analytics for QlikView.
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')
Go to Solution.
Set analysis can not branch. It can only filter. Your if statements do branch so you cannot replace them with set analysis expressions.
Thanq verymuch Gysbert.
Learnt new thing