Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor

Set Analysis for "IF" Statement

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')

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Set Analysis for "IF" Statement

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Set Analysis for "IF" Statement

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Valued Contributor

Re: Set Analysis for "IF" Statement

Thanq verymuch Gysbert.

Learnt new thing