topic Re: Nprinting 17 - Multiple filters on user level for different reports in Qlik NPrinting

Nprinting 17 - Multiple filters on user level for different reports

Rqat — Wed, 25 Sep 2019 18:40:54 GMT

Hi all!

I'm having some issues understanding how to overcome a "problem" in Nprinting 17. Example:

If I have a user that's going to receive say 3 different reports from the same template and containing the same object but with different publish tasks from the same application that holds Sales, Invoice and Purchase and I want Nprinting to apply different filters to this user depending on what kind of report it is.

I'll add filters on user level for Todays Sales, Yesterdays invoice and this months purchase from the same date-table, so this user now have a total of 3 filters. Is there any way possible now to instruct Nprinting what filters should be applied to what publish task? If there's only one user I can just apply the filters on the task level but if I have several users that use different filters this is not possible.

So the issue is when I want one user to receive different reports from the same application while applying different filters on user level so I don't disturb any other user reports.

I have a work around that's quite complex with 3 different import tasks that updates the users filters in between the publish tasks so that the filters on user level only contain 1 value and then updates after every import. Does anyone know some easier solution to this? I've tried using "override values" but then only the last filter in the hierarchy is applied since Np17 don't know on what task the filters should be applied to.

Kind regards,

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Thu, 30 Nov 2017 08:20:45 GMT

You need to create 3 separate connections to the same Qlik document and when importing filters link them using those 3 connections so they will not interfere with each other and esentialy they will work as an independent filters.

Build each report on separate connections.

that is the most common and recommended solution.

regards

Lech

Re: Nprinting 17 - Multiple filters on user level for different reports

Rqat — Thu, 30 Nov 2017 08:42:37 GMT

Hi Lech,

Thank you for the quick response!

So given that I have the setup above, what happens if I want to filter different values from the same field on a user level? It feels like I'm stuck with the same issue again. Maybe my explanation was quite bad but the issue is that I want a users filter to be applied to different reports connected to the same application. And from there I want the correct filter to apply to the correct report, not applying all filters or use override and only apply the last one.

Or does your solution work on a user level as well? I might need to rename the filters to the maybe Month_Sales, Month_Invoice, Month_Purchase - is that what you mean?

What I'm looking for blunt is to kind of to be able to connect a users filter to a report, and not have it to apply to all reports that's sent out to the user.

Kind regards,

Robert

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Thu, 30 Nov 2017 08:52:47 GMT

My solution is:

User A gets 3 reports with user dependant filters
- Connection A drives Report 1 with Filters based on Connection A
- Connection B drives Report 2 with Filters based on Connection B
- Connection C drives Report 3 with Filters based on Connection C

Connections A,B,C are connecting to single QlikVIew or Qlik Sense document (but because they are differnet connections filters from B are not applied to A or C and so on...

Just try and test it....

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Thu, 30 Nov 2017 22:51:08 GMT

Looks like it works

Re: Nprinting 17 - Multiple filters on user level for different reports

Rqat — Fri, 01 Dec 2017 12:54:22 GMT

Yes! Thanks for you quick response

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Fri, 01 Dec 2017 13:06:39 GMT

‌awesome. I am glad i could help. Have a joce weekend!

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Fri, 01 Dec 2017 13:07:31 GMT

....‌(phone typing). Have a nice weekend!

Re: Nprinting 17 - Multiple filters on user level for different reports

Rqat — Fri, 01 Dec 2017 13:10:22 GMT

I also wish you a "joce" weekend! Thanks!

Re: Nprinting 17 - Multiple filters on user level for different reports

sujeet_shirude — Wed, 13 Jun 2018 12:53:45 GMT

Hello Robert & Lech!

I applied two separate filters using two separate connections to the same user.

Connection A drives Report 1 with Filters based on Connection A
Connection B drives Report 2 with Filters based on Connection B

Can I reuse the groups to which the users belong for creating new tasks? Thank you!

Regards,

Sujeet Shirude

Re: Nprinting 17 - Multiple filters on user level for different reports

Rqat — Fri, 07 Sep 2018 10:02:03 GMT

Hi again,

I just want to hear if there's something new on the roadmap that someone has heard about regarding this issue. I find that making several connections like this is a little bit clunky and would love to have some kind of filter cycle or similar. Do you still resolve these issues with this method or have you found something new?

Regarding your question Sujeet, Yes I believe so!

Kind regards,

Robert

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Sat, 08 Sep 2018 02:24:25 GMT

I would not expect different approach in this area. It works and it works as designed.

I am not aware of anything new in this area or anything on the roadmap

regards

Lech

Re: Nprinting 17 - Multiple filters on user level for different reports

Rqat — Sat, 08 Sep 2018 07:47:58 GMT

Hi Lech,

Thanks for the quick response, always nice with a guru in Nprinting

I feel like this solution, in a big envoirnment, will be VERY clunky. For example I had a report that I transferred from np16 to np17 recently where they filtered the report on a user level meaning they imported 4 of the same user for the report to filter in 4 different ways (same report structure etc just different office's).

In nprinting17 you need to have a unique email adresses and hence this is not possible. So the concluision here is that I have to create 4 different connections to 4 different reports and 1 task maybe just to have the report filtered 4 different ways to the same user? Doesn't that mean my web console will be flooded with connections, reports etc? Or have I missed something?

Kind regards,

Robert

Re: Nprinting 17 - Multiple filters on user level for different reports

Lech_Miszkiewicz — Mon, 10 Sep 2018 02:03:07 GMT

I agree, It can become clunky...

On the other hand. If you are sending the same template report just with different selections to users maybe you would be able to create a grouping dimension which effectively would be set of filters for a recipient in qlik app and on nprinitng side you could then cycle through this dimension?

This might seem like pulling a leg, but i thought i would also throw this idea - as in some instances it might be helpful.

cheers

Lech