Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank You so muc. it works!
=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