https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1893923#M1217421 <P>Thank you so much for your answer and idea.</P> Wed, 16 Feb 2022 18:38:28 GMT marina24 2022-02-16T18:38:28Z https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1892980#M1217377 <P><SPAN>Hello, experts.</SPAN></P> <P>I have a table with a field "Key". This field contains several thousand different values.</P> <P>How can I filter this table by 300 values of this field?</P> <P>It's not a one-time task. Our users often need to filter table by selecting a large number of values.</P> <P>Is it possible to do it in QlikView?</P> Tue, 15 Feb 2022 10:16:26 GMT https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1892980#M1217377 marina24 2022-02-15T10:16:26Z https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1893384#M1217391 <P>maybe like this:<BR /><BR /></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarcoWedel_0-1644958653741.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72366i1A02624F7BA169B2/image-size/medium?v=v2&amp;px=400" role="button" title="MarcoWedel_0-1644958653741.png" alt="MarcoWedel_0-1644958653741.png" /></span>&nbsp; &nbsp; &nbsp; &nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MarcoWedel_2-1644958702718.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/72368i081AE58B9BC5941F/image-size/medium?v=v2&amp;px=400" role="button" title="MarcoWedel_2-1644958702718.png" alt="MarcoWedel_2-1644958702718.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">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); </LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 15 Feb 2022 21:03:29 GMT https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1893384#M1217391 MarcoWedel 2022-02-15T21:03:29Z https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1893923#M1217421 <P>Thank you so much for your answer and idea.</P> Wed, 16 Feb 2022 18:38:28 GMT https://community.qlik.com/t5/QlikView/Filtering-data-by-a-large-number-of-values/m-p/1893923#M1217421 marina24 2022-02-16T18:38:28Z