topic Re: String result Ifs in QlikView

String result Ifs

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: String result Ifs

mightyqlikers — Fri, 24 Jun 2016 08:31:03 GMT

hi,

share sample data.

$@M.

Re: String result Ifs

varshavig12 — Fri, 24 Jun 2016 09:13:52 GMT

Try this:

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

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

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

Re: String result Ifs

vcanale — Fri, 24 Jun 2016 10:02:54 GMT

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')))

Re: String result Ifs

PrashantSangle — Fri, 24 Jun 2016 11:15:58 GMT

Hi,

Third if not necessary

try like

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

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

Regards

Re: String result Ifs

jonathandienst — Fri, 24 Jun 2016 11:19:06 GMT

You can simplify further:

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

Re: String result Ifs

sunny_talwar — Fri, 24 Jun 2016 11:44:44 GMT

I think you guys mean 660

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