Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
johnatkinson
Contributor
Contributor

Flexible Filter Selection and/or Filter Upload Function

This question keeps popping up over and over again - i.e. how can any user apply a mixed set of Product numbers or Customer numbers that will become the filter of the sheet in question. For example, in our 'ancient' SAP BW queries it's really simple to upload a .txt file containing 100+ Products - which then appears as the filter and shows only the sales data for those Products. This is really handy when the Products are scattered across the Product Hierarchy - i.e. no easy way to select in Qlik Sense apart from typing in each one individually (forget it), or creating a massive script that's not re-usable next time around. 

1 Reply
OmarBenSalem
Partner - Champion II
Partner - Champion II

Well, u can apply the same thing:

a file containing:

Product, Filter

prd1, filter1

prd2,filter1,

prd3,filter1,

prd4,filter2 

etc

associate this file (table) to ur table containing ur products, and then when u select the value filter1, u'll select products1,2 and 3..