Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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);
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);
Thank you so much for your answer and idea.