Or selection

[juriengroot]

Hi,

I was wondering what the best way is to achieve an OR selection.

I have in my dataset [From Country] and [To Country]. Sometimes users want to select, Where [From Country] = Netherlands or [To Country] = Netherlands.

I can create a [Lane] = [From Country]& "|" & [To Country]. People can then filter in Lane via *Netherlands*, but there is no easy way to select all the options that appear.

I have tried another solution where users can select from an inline table "Country" multiple countries.

if(Wildmatch([Lane], '*'&[Country]&'*'), 'Yes', 'No')

But if you select the Yes value, I don't get a nice result. One country is working fine via a variable setup:

if(Wildmatch([Lane], '*'&vCountry&'*'), 'Yes', 'No'), but you can use only one country and the variable needs to be defined & you need to filter via 'Yes'.

People know a better way to create the OR selection?

[Anonymous · Accepted solution]

While I don't know if the OR selection is possible in Qlik Sense, as far as easily selecting, can't you just hit ENTER after you put in your filter criteria? That should select everything that is highlighted.

[juriengroot]

Thanks, so weird. I felt that I tried it so often, but never succeeded. It totally works!