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: 
iliaisyah
Contributor III
Contributor III

Range Expression for Multibox

Hi,

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

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be alternative? 🙂

=if(A>=0.5 and A<=0.9, 'Mid', if(A>0.9, 'Hi', if(A<0.5, 'Low')))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
iliaisyah
Contributor III
Contributor III
Author

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

sivakumar1994
Contributor III
Contributor III

its because A value is not number , it is read as 100% or 50%. either use subfield function in script or use below expression instead

and most importantly delete the g53 column in your attached excel (=if(A>=90 and A<=50,'Mid',if(A>=90,'Hi',if(A<50,'Low'))) ).

The Logic for mid is wrong i.e a>=90 and a<=50 ( there is no number greater than 90 and lesser than 50)
Please find correct expression and corrected excel file .

=if(CEil(num(subfield(A,'%',1)*100)) <=90 and ceil(num(subfield(A,'%',1)*100))>=50,'Mid',if(ceil(num(subfield(A,'%',1)*100)) >=90,'High',if(ceil(num(subfield(A,'%',1)*100)) <50,'Low')))

Anil_Babu_Samineni

May be alternative? 🙂

=if(A>=0.5 and A<=0.9, 'Mid', if(A>0.9, 'Hi', if(A<0.5, 'Low')))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sivakumar1994
Contributor III
Contributor III

please find the corrected excel file and my output attached.

image.png

 

iliaisyah
Contributor III
Contributor III
Author

thank you so much for the corrected excel. i will use this