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')
Set analysis can not branch. It can only filter. Your if statements do branch so you cannot replace them with set analysis expressions.
View solution in original post
Thanq verymuch Gysbert.
Learnt new thing