Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

Help with list box expression with multiple 'if' conditions

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

4 Replies
prat1507
Specialist
Specialist

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
Creator
Creator
Author

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
Specialist
Specialist

PFA the app.

Or
MVP
MVP

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