Limited records in List box

[prma7799]

Hi All,

How to show some of few records in to the list box .

For Ex:

The below counties are present in my list box as Country

MAURITIUS

SWEDON

USA

NEW ZEALAND

SOUTH AFRICA

NAMIBIA

IVORY COAST

THAILAND

UGANDA

CANADA

MYANMAR

KENYA

SRI LANKA

MALAYSIA

GREECE

CROATIA

NETHERLAND

AUSTRALIA

UNITED KINGDOM

CHILE

IRELAND

UKRAINE

BOLIVIA

TANZANIA

YEMEN

INDIA

GERMANY

But I want to show only few like below

SRI LANKA

UNITED KINGDOM

IRELAND

TANZANIA

INDIA

Thanks

[Chanty4u]

create a bookmark ..and apply that bookmark

orelse   chk option    Hide excluded in general tab

[#3]

‌Hi

YOu can limit the data in script

and also you can limit the values via put condition in expression tab of list box

[prma7799]

How can we write condition in expression tab....

[marcus_sommer]

You could use a listbox-expression like:

if(match(Country, 'A', 'B', ...), Country)

- Marcus

[Kushal_Chawda]

It's better You create the field in script like below

LOAD ...

if(match(Country,'SRI LANKA','UNITED KINGDOM','IRELAND','TANZANIA','INDIA') , Country) as CountryNew

...

FROM table

Now you can use this Field in Listbox

Update :Corrected IF

[trdandamudi · Accepted solution]

The best thing is to filter out the needed countries in the script as a separate field. The other option is you can use below in the List box -expression:

=if( mixmatch([Country], 'SRI Lu ANKA','UNITED KINGDOM','IRELAND','TANZANIA','INDIA'), [Country])

[sunny_talwar]

May be flag these in the script as 1 and then use the flag like this:

If(Flag = 1, COUNTRY)

[#9]

HI

GO to list box properties

there select expression option under the field option in general tab

write logic a below

=if(match(country,

SRI LANKA

UNITED KINGDOM

IRELAND

TANZANIA

INDIA

)

PLz put country names in quots