topic Re: Help with list box expression with multiple 'if' conditions in QlikView

Help with list box expression with multiple 'if' conditions

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Attached is my qvw file with sample date and requesting your help with an expression to create a list box with the following conditions.

If Total days = blank---->'Never loggedin'

If Fill Rate Admin >90% ----> 'High'

If Fill Rate Admin >=80% and <90%---> 'Medium'

If Fill Rate Admin <80%----> 'Low'

Appreciate your help.

Thanks,

Ram

prat1507 — Tue, 03 Oct 2017 11:29:05 GMT

Please use

=if([Total Days]='','Never loggedin',

if(replace([Fill Rate Admin],'%','')>90,'High',

if(replace([Fill Rate Admin],'%','')>=80 and replace([Fill Rate Admin],'%','')<90,'Medium',

if(replace([Fill Rate Admin],'%','')<80,'Low'))))

ramanarayan — Tue, 03 Oct 2017 11:37:36 GMT

Hi Pratyush,

Thanks for your help.

But unfortunately, i see only 'Low' in my list box. i dont see other options available.

Thanks,

Ram

prat1507 — Tue, 03 Oct 2017 11:39:01 GMT

PFA the app.

Or — Tue, 03 Oct 2017 11:41:34 GMT

I was about to offer up the same answer as Pratyush. His example works - I tested it with your file.