topic Re: Only with If expression in QlikView

Only with If expression

Anonymous — Mon, 06 Feb 2017 16:50:08 GMT

I have an If statement that I am using that works well and an Only expression that works, but I am having trouble combining them. Can anyone help me figure out the correct way to combine these into one expression?

IF(Significance_Industry >=.6,'H',IF(Significance_Industry < .3,'L'

,IF(Significance_Industry < .6 and Significance_Industry >= .3,'M','L'))))

only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry)

Re: Only with If expression

sunny_talwar — Mon, 06 Feb 2017 17:19:40 GMT

May be this:

If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) >= .6,'H',

If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) < .3, 'L',

If(Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) < .6 and

Only({<IsOpen={1}, Source={'ClientOppInfo'}>} Significance_Industry) >= .3, 'M', 'L'))))

Re: Only with If expression

Anonymous — Mon, 06 Feb 2017 19:39:25 GMT

Thank you that worked great, I just had to remove one of the parenthesis at the end. One too many it seems. I really appreciate the help.