topic Re: How to filter a report by one field with multiple values? Users want same report but delivered based on filter on one field in Qlik NPrinting

How to filter a report by one field with multiple values? Users want same report but delivered based on filter on one field

jblomqvist — Fri, 20 Apr 2018 06:41:10 GMT

Hi,

I have an NPrinting report that needs to be delivered to multiple users with different values on the same field.

For example the app is Sales app.

User 1 wants a report delivered where it is filtered on Country = France, Germany, UK

User 2 wants the same report delivered where it is filtered on Country = USA, Sweden, France, Belgium

User 3 wants the same report where it is filtered on Country = Australia, New Zealand

It is the same report but delivered to users using different values on the same field.

How can I implement this efficiently?

Re: How to filter a report by one field with multiple values? Users want same report but delivered based on filter on one field

Ruggero_Piccoli — Fri, 20 Apr 2018 08:16:22 GMT

Hi,

Do the following:

create the filters (of course I suppose you already have a working connection) https://help.qlik.com/en-US/nprinting/September2017/Content/FiltersCycles/Filters.htm
assign filters to users https://help.qlik.com/en-US/nprinting/September2017/Content/Security/Intro-Security.htm‌. Users and filters can be imported from Excel files.
create a publish task, add users and reports https://help.qlik.com/en-US/nprinting/February2018/Content/AdministeringQVNprinting/MonitorKillTasks/Creating-tasks.htm

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: How to filter a report by one field with multiple values? Users want same report but delivered based on filter on one field

jblomqvist — Fri, 20 Apr 2018 09:09:10 GMT

Hi Ruggero,

Thank you for this.

How can I select multiple countries in a filter?

In the Fields tab of a filter, do I simply click Values and add multiple "Value is" rows with a different country each time?

Re: How to filter a report by one field with multiple values? Users want same report but delivered based on filter on one field

Ruggero_Piccoli — Fri, 20 Apr 2018 09:24:23 GMT

Yes, you can select multiple values for the same field. Just add a row for each value.

Best Regards,

Ruggero

---------------------------------------------