topic Re: Re: particular values in list box in QlikView

particular values in list box

arulsettu — Thu, 06 Feb 2014 06:15:12 GMT

i displayed country in listbox. now i need to display particular countries. i used WHERE CLAUSE but i am able to display single country.

how can i do that any help? thanks...

Thu, 06 Feb 2014 06:28:48 GMT

In expression use llike :listbox->properties->field->find <expression>-then write

if(match(country,'india','usa','uk'),country)

i hope it helps u

regards

Mahesh

arulsettu — Thu, 06 Feb 2014 06:32:22 GMT

HI Mahesh

it showing all the country and matching country...

Thu, 06 Feb 2014 06:39:13 GMT

can u pls post me screen shot about u r requirement.

let me confirm you selected <expression> instead of country.

arulsettu — Thu, 06 Feb 2014 06:40:54 GMT

its like this

i need to show like this

Thu, 06 Feb 2014 06:45:29 GMT

Check the attached and select <expression> in field instead of Name .edit and write given above given condition

if(match(Name,'india','usa','uk'),Name)------------------------------->Name means u r field name

regards

Mahesh

Thu, 06 Feb 2014 06:49:06 GMT

Plz find attachment...Its solve ur problem..

Regards,

arulsettu — Thu, 06 Feb 2014 06:49:15 GMT

thank you very much mahesh...