add more if in one expression

[iliaisyah]

Hi. 

i wish to make the range like this

ABW range >20 = high

ABW 5 -20 = Medium

ABW less than 5 = low

my script for medium is ok as below

=if((Act_Yield01/BunchCount01)*1000>=5 and (Act_Yield01/BunchCount01)*1000<=20,'Mid')

but i dont know how to insert for high and Low

[zzyjordan · Accepted solution]

try this nested if statement

=if((Act_Yield01/BunchCount01)*1000>=5 and (Act_Yield01/BunchCount01)*1000<=20,'Mid',if((Act_Yield01/BunchCount01)*1000>20,'High','Low'))

ZZ

[iliaisyah]

Thank You so muc. it works!

[rwunderlich]

=if((Act_Yield01/BunchCount01)*1000 > 20, 'high'
,if((Act_Yield01/BunchCount01)*1000 >= 5, 'med'
,'low))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com