topic Re: show Some values in list box in QlikView

show Some values in list box

Anonymous — Thu, 15 May 2014 06:44:07 GMT

I need selected values in list box

Take Example If i Take Empid it contains values like (12.13.14.15,16,17,23,34,45,65,38.32,20,76,54,22) Here in if select sheet object as

list box for Empid then it display all values but i need only have to display in when i create list box then it shows only these values like(23,54,65,38,16) but Don't change in script I need this through expression only in list box

Re: show Some values in list box

amit_saini — Thu, 15 May 2014 07:18:56 GMT

Hi Rajesh,

Please see the attachment , hope this will help you.

Thanks,

Re: show Some values in list box

arulsettu — Thu, 15 May 2014 07:51:31 GMT

hi try this

if(match(Empid,'23','54','65','38','16'),Empid)

hope ti helps

Re: show Some values in list box

Anonymous — Thu, 15 May 2014 12:25:07 GMT

tnx Arul it is working and one more i need how can i place these in inputbox can you please tell me how??

Re: show Some values in list box

arulsettu — Thu, 15 May 2014 13:16:42 GMT

if you are ok with the answer plz mark it as answer it would be help full for others

create a input box then IN title =if(match(Empid,'23','54','65','38','16'),Empid)

do like this