Filter - contains

[nickmarlborough]

Hi,

I have a dataset with each row unique to a unique identifier. Each unique identifier has a city associated to it, some more than one. 

for example;

XX - London

XY - London, New York

XZ - New York, London

Currently the table is in a filter pane, however using this example, when I type ‘London’ in the city column, only XX and XY appear and not XZ because London is after ‘New York’ in the string. How can I do it so that the filter searched the entire field for ‘London’

would this be in the load editor?

thank you. 

[rwunderlich · Accepted solution]

A simple solution is to type wildcards in the search. e.g.

*lon*

-Rob

[Vegar · Accepted solution]

Rob't tip on using wildcards  ** in your search will work. For more  details about searching in filter panes and other objects is found here:  Text search | Qlik Sense on Windows Help