topic Re: Range Expression for Multibox in QlikView

Range Expression for Multibox

iliaisyah — Sat, 16 Nov 2024 21:15:57 GMT

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

Re: Range Expression for Multibox

iliaisyah — Tue, 12 Mar 2019 09:38:35 GMT

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

Re: Range Expression for Multibox

sivakumar1994 — Tue, 12 Mar 2019 09:50:59 GMT

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')))

Re: Range Expression for Multibox

Anil_Babu_Samineni — Tue, 12 Mar 2019 09:52:16 GMT

May be alternative? 🙂

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

Re: Range Expression for Multibox

sivakumar1994 — Tue, 12 Mar 2019 09:52:24 GMT

please find the corrected excel file and my output attached.

Re: Range Expression for Multibox

iliaisyah — Wed, 13 Mar 2019 01:32:06 GMT

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