Filter with where and several results of one field

[Magogar]

Hi!

I need to filter for several results of a field. I don't know how to write it.

This syntax is not working:

where client in (1,2,3,4,5)

how can i write it?

Thanks!

[UncleRiotous]

Try

If(client<=5,client,Null())

You don't actually need the Null() as if you don't include the second comma it will return a null for any false value.

[maxgro · Accepted solution]

another one

where match(client, 1,2,3,4,5)

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Scripting/Condi...

[oskartoivonen · Accepted solution]

The closest comparison to T-SQL in (x, y, z...) syntax is to use the Match()-function.

TableName:
LOAD
    Client
FROM
    Table.qvd (qvd)
WHERE
    Match(Client, 1, 2, 3, 4, 5);

[Magogar]

Thank you, but I need it for text or numbers.

[oskartoivonen]

Match()-function allows for both number and text search. Use single quote to signal to Qlik it's a string.

Match(Client, 1, 2, 3, '4', '5')