How to dynamically add filter values to NPrinting report
I am a beginner in NPrinting and I need some guidance.
I have created a report that needs to be sent to 20 recipients. Each recipient should receive a version of the report filtered by their specific zone. The zones already exist in a Qlik Sense table, and I have successfully set up the filters.
My question is: how can I dynamically include the zone name in the following elements: - The report header (to display the zone value) - The email subject when sending the report - The report file name (if possible)
The main challenge for me is not the filtering itself, but how to inject the corresponding zone value dynamically into these elements for each recipient.
@Noura18 - indeed the answer is to use variables but the very first thing to do is to create such variable in Qlik Sense. You can call it say vZone and assign formula "=Only(Zone)" where Zone is the field representing zone. Also note that my variable expression starts with "=" sign and this is critical for variable to expand/evaluate properly when called from NPrinting. If you are filtering down to more than one Zone you may need to use "=Concat(Distinct Zone,'|')" as your variable expression to allow for more than 1 value.
Once you create such variable in your Qlik Sense app you need to publish your app again, regeneretate metadata and then you can indeed add it to all those places:
in report header - you would use NPrinting Designer and bring in the variable
in report file name - use dynamic file name option and pick it from dropdowns:
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
