Filtering data by a large number of values

[marina24]

Hello, experts.

I have a table with a field "Key". This field contains several thousand different values.

How can I filter this table by 300 values of this field?

It's not a one-time task. Our users often need to filter table by selecting a large number of values.

Is it possible to do it in QlikView?

[MarcoWedel · Accepted solution]

maybe like this:

       

LOAD KEY
FROM
[test1502.xlsx]
(ooxml, embedded labels);


tabValueFilter:
LOAD A as KEY,
     'ValueFilter' as ValueFilter
FROM [https://community.qlik.com/cyjdu72974/attachments/cyjdu72974/qlikview-app-development/1217377/2/300%20values.xlsx] (ooxml, no labels, table is Лист4);

[marina24]

Thank you so much for your answer and idea.