Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
markgraham123
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
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
2 Replies
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
markgraham123
Valued Contributor

Re: Set Analysis for "IF" Statement

Thanq verymuch Gysbert.

Learnt new thing