Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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..