Recipient filter - how to create a dynamic filter

[agigliotti]

Hi,
I'd need to distribute an excel report to sales agents applying the correct data reduction using the sales agent code as filter.
Is it possible to create a unique filter for all sales agents in order to send the right data (filtered on sales agent code) to the right person?
Please let me know.
Many thanks in advance for your time.
Best Regards

@Ruggero_Piccoli @Andrew_Kruger @Frank_S @JonnyPoole 

[Frank_S]

I didn't see one so I created a feature request.

• Tabular reporting recipient import file filter creation - https://ideation.qlik.com/app/#/case/42843...

Please visit, comment on and vote for it at the above link. You must be signed on to do so.

I am sure R&D are aware of this but nevertheless, do vote and comment to get traction behind it.

Kind regards...

[Liam-Grant]

Thanks for this, it has been a real lifesaver! Just one issue, the Raw API request to get all Report Filters (in the Delete Automation) can only return 20 records at a time, so if your app has more than 20 Report Filters, you will need to run it multiple times (I have to do it 5 times to catch all of the Filters). I wonder if it is pagination maybe? Or just a limit with that API request

[Supersmurf]

Hi @Liam-Grant! That's a good observation (the 20 filter limit) and something we should be able to solve. I did this as prototype with only a handful of recipients. Will have a look and post updates here.

Regards

Jan

[Supersmurf]

Hi! The Raw API Request limit can be raised to 100 by adding parameter limit. Setting it to 1000 failed, so not a good solution. Attached is a new version of the delete filter automation that loops as long as the next page href is not equal to the self (current page) href.

[Liam-Grant]

Ahh that makes sense. Thank you that works now with a single run, though in my case with ~90 filters it goes over the 60 second automation time limit so I have had to set it to run asynchronously and add a 2 min sleep command to my load script (which all works fine). Fingers crossed Qlik actually add a nice way to manage these soon as it feels a bit like an afterthought