Default multi selection on qliksense sheet

[Emerald]

TableA: 

Country	States
Canada	Ontario
Australia	Brisbane
UK	London
UK	Scotland
USA	California
USA	Texas

when opens the sheet 
the default selections would be filtered on the States for the Countries  'USA',  'UK'
writtend the following:
=concat({1<Country={'UK','USA'}>}distinct [States],'|')
but is still not working as expected, the default selection is not showing when open the app.
Please help?

[jochem_zw]

How do you apply the default selection, by a bookmark, or by sheet action?

if done by action than the action need to be 'Select Values matching search criteria'  and the expression is:

='('&concat({1<Country={'UK','USA'}>}distinct [States],'|')&')'

[Anil_Babu_Samineni]

I will recommend to create bookmark and use that as default bookmark to the sheet that you want to select.

[sidhiq91]

@Emerald  Creating bookmark and add them under sheet action would be a better option.

[Emerald]

Load * Inline [
Country, States
Canada, Ontario
Australia, Brisbane
UK, London -123&
UK, Scotland_
UK, Ireland
USA, California
USA, Texas];

but when have the special characters on the states then it is not working as expected

[jochem_zw]

This should work, also with the special characters:

='("'&concat({1<Country={'UK','USA'}>}distinct [States],'"|"')&'")'

[anat]

in sheet actions select "Select values matching search criteria" option

field as "Country"

values: US;UK