topic Re: add more if in one expression in QlikView

add more if in one expression

iliaisyah — Thu, 17 Jan 2019 02:32:28 GMT

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

Re: add more if in one expression

zzyjordan — Thu, 17 Jan 2019 03:17:20 GMT

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

Re: add more if in one expression

iliaisyah — Thu, 17 Jan 2019 03:41:09 GMT

Thank You so muc. it works!

Re: add more if in one expression

rwunderlich — Thu, 17 Jan 2019 03:44:47 GMT

=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