Discussion board where members can get started with QlikView.
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.
=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'))))
Thanks for your help.
But unfortunately, i see only 'Low' in my list box. i dont see other options available.
PFA the app.
I was about to offer up the same answer as Pratyush. His example works - I tested it with your file.