This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
im trying to put range as below
'=if(A>=90 and A<=50,'Mid',if(A>=90,'Hi',if(A<50,'Low')))
but the only expression i get for drop down is Low
I with to have it Hi Mid and Low
This is for expression of Multibox
here is the excel
appreciate if you can copy paste the expression here
May be alternative? 🙂
=if(A>=0.5 and A<=0.9, 'Mid', if(A>0.9, 'Hi', if(A<0.5, 'Low')))
View solution in original post
Due to numbering system in my excel,
=if(A>=0.9 and A<=0.5,'Mid',if(A>0.9,'Hi',if(A<0.5,'Low')))
if have succeed to produce Hi and Low but not Mid.
im not sure what wrong with that range
please find the corrected excel file and my output attached.