List of items I want to filter out in Data Manager

[Manuel174102]

Hello everyone. 

I want to filter out some items in the data manager. Those are a list of items. How could I do it at once?

I have been trying the following but it doesnt work.

where:

"Document"<>  ('17407','17384','18942',18493')

"Document"<>  ['17407','17384','18942',18493']

"Document"<>  {'17407','17384','18942',18493'}

thanks in advance

[justISO · Accepted solution]

Hi, probably it is easier to do it 'Data load editor' -  with match() function for this, just add WHERE clause below FROM:

Load

...

From ...

WHERE not match(Document, '17407','17384','18942',18493');

[Manuel174102 · Accepted solution]

hey, thanks for answering. 

when I write that formula, the "not" is highlighted in red. 

it doesnt work 😞

[justISO]

does your FROM line ends with ';'? you should remove it, as WHERE clause is part of LOAD and ';' should be last of WHERE.

[Manuel174102]

thank u!! it worked now!

i have another problem now hahaah 

Something weird happens with my graph. HELP PLEAS... - Qlik Community - 1985931

do u have a clue what is going on?