topic Re: NPrinting: Filters on Groups workaround? in Qlik NPrinting

NPrinting: Filters on Groups workaround?

JustinDallas — Mon, 18 Jun 2018 15:22:36 GMT

Hello Folks,

I have an NPrinting issue. I'll try to paraphrase the problem. Lets say I have a table called "Revenue by US State" in my Qliksense dashboard. In NPrinting, I have users that should only receive certain states. My thinking was that I could create 50 Groups with their respective filters, and import them. Then when the report ran, the filter would be applied and the report would be sent to the Group.

However, there is no ability to add a Filter to a Group. So would I have to have 50 tasks, each with their own filter, or would I have to have 50 reports, each with their own filter.

Re: NPrinting: Filters on Groups workaround?

Daniel_Jenkins — Tue, 19 Jun 2018 03:11:33 GMT

Hi Justin,

Single Publish Task containing a Single report and a single Group. Group to contain all required NPrinting Users and each User should have a User filter assigned that filters for which state(s) they are entitled to get reports for. Of course you can simply add all the users into the Task and dispense with Groups but I tend to favor Groups as they make it easier to maintain Task recipients. NPrinting will take care of the rest.

HTH - Daniel.

Re: NPrinting: Filters on Groups workaround?

JustinDallas — Tue, 19 Jun 2018 13:36:57 GMT

So what happens if I need a User two states? And what happens if I add a filter to a user that doesn't doesn't exist in their other reports?

Re: NPrinting: Filters on Groups workaround?

Daniel_Jenkins — Tue, 19 Jun 2018 22:59:16 GMT

Hi Justin,

A User level filter can contain multiple fields and multiple values. So your User can have a filter that includes both states. E.g., State={'NY','FL'}. The report will be filtered to contain both states. If you want separate reports for each state look at the Cycle option. https://help.qlik.com/en-US/nprinting/April2018/Content/ReportsDevelopment/Cycling-your-reports.htm

Regarding your second point, do you mean for example User1 has a filter State={'NY'} but you don't want to apply this filter for this user in a different report? If so, note that User level filters will always be applied if that user is a recipient in the Publish Task. You can run an Import Task that edits/removes those filters (by setting the appropriate import action) before running your second Publish Task. See: https://help.qlik.com/en-US/nprinting/April2018/Content/DeployingQVNprinting/Import-Users-Filters.htm

HTH - Daniel.