Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

particular values in list box

Hi

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...

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

7 Replies
Not applicable

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
Master III
Master III
Author

HI Mahesh

it showing all the country and matching country...

Not applicable

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

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

arulsettu
Master III
Master III
Author

its like this

Capture.PNG.png

i need to show like this

Capture.PNG.png

Not applicable

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

Not applicable

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

Regards,

arulsettu
Master III
Master III
Author

thank you very much mahesh...