String result Ifs

[#1]

Hi, I am new to QlikView..

I want to create some sort of notification based on the number of stock available.

So, once stock drops under 330, I would signal the word 'ASAP', above that would be 'OK'.

Or probably can add 'Review' when the Stock goes between 330 and 660.

I tried this if(Sum(Stock)) << 330, 'ASAP', 'OK')  // I already tried with only Stock, Sum(Stock) and even using Nums... But the result, everything becomes ASAP.

Can anyone please share their guidance?

Thank you

[mightyqlikers]

hi,

share sample data.

$@M.

[varshavig12]

Try this:

if(Sum(Stock) <330, 'ASAP',

if(Sum(Stock) =>300 and Sum(Stock)<= 600 'Review',

if(Sum(Stock) > 600 ,'OK')))

[vcanale]

Hi,
try:

if(Sum(Stock)<= 330, 'ASAP', 'OK')

or:

if(Sum(Stock) < 330, 'ASAP',

     if(Sum(Stock) >=330 and Sum(Stock)<= 660,  'Review',

          if(Sum(Stock) > 660 , 'OK')))

[PrashantSangle]

Hi,

Third if not necessary

try like

if(Sum(Stock) <330, 'ASAP',

if(Sum(Stock) =>300 and Sum(Stock)<= 600, 'Review','OK'))

Regards

[jonathandienst]

You can simplify further:

=if(Sum(Stock) < 330, 'ASAP', if(Sum(Stock) <= 600, 'Review', 'OK'))

[sunny_talwar]

I think you guys mean 660

=if(Sum(Stock) < 330, 'ASAP', if(Sum(Stock) <= 660, 'Review', 'OK'))