I have created a report that must be filtered based on the Supervisor ID. In my data set I currently have over 400 supervisor ID's. I want to distribute the report for each individual supervisor. My concern is that the only was I can think of achieving is creating 400 Filters and 400 tasks.
Is there a way to create a condition or something similar which will dynamically distribute the report without me manually creating 400 filters and 400 tasks ? The other issue with the manual filter is that I wont be able to cater for removed/added supervisors.
You need to create 400 filters, one for each supervisor, and associate each filter to its related supervisor. Than create a single publish task, not 400, add the supervisors as user and distribute the reports as you prefer, for example via email. Each supervisor will receive a filtered report.
Best Regards, Ruggero --------------------------------------------- When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
So basically the report will not be sent to the individual supervisor however will be distributed to a folder and the report will be filtered based on the Supervisor field in the data.
So basically if we have 100 stores for example and we want to generate a report per store and save the reports in a location with the store name on the report name how would we achieve that? Please note we are not sending the report but distributing to a folder - 1 folder.