topic Re: How to create filter in Nprintng For conditional as below. in Qlik NPrinting

How to create filter in Nprintng For conditional as below.

arvind_patil — Thu, 05 Oct 2017 10:57:15 GMT

Hi Experts,

Condition is as follows

I have one task In Nprinting.

- In that task i have 3 reports(Report1, Report2,Report3).

-I have assigned 5 users to that task(U1,U2,U3,U4,U5).

-In all that report Area Manager is common filed.( filter apply on Area Manager)

Now My requirement is :

1. U1 must see only Area Manager= A1 Data for Report1, Report2 and All Data For Report3

2. U2 must see only Area Manager= A2 Data for Report1, Report2 and All Data For Report3

3. U3 must see only Area Manager= A3 Data for Report1, Report2 and All Data For Report3

4. U4 must see only Area Manager= A1,A2, Data for Report1, Report2 and All Data For Report3

5. U5 must see only Area Manager= A1,A3, Data for Report1, Report2 and All Data For Report3

In short filter apply only Report 1 and 2 Based on User.

Thanks,

Arvind Patil

Re: How to create filter in Nprintng For conditional as below.

Chanty4u — Thu, 05 Oct 2017 11:08:46 GMT

add user ,and report name for each level and apply the same to all

Re: How to create filter in Nprintng For conditional as below.

arvind_patil — Thu, 05 Oct 2017 11:14:46 GMT

How could explain little bit more.

Re: How to create filter in Nprintng For conditional as below.

mkelemen — Thu, 05 Oct 2017 11:20:20 GMT

Hi,

you can create a filter with Area Manager set to Override values (=clear selections) and add it to Report3.

Since the filters are evaluated in order task -> user -> report -> object it will override the user level filters.

You can find more info here Static and dynamic filters ‒ Qlik NPrinting.

BR,

Matus

Re: How to create filter in Nprintng For conditional as below.

Chanty4u — Thu, 05 Oct 2017 11:21:38 GMT

in filter you can add user and sepecif reports to see

and in add fields you can add more level wise also.

and if you want you can create user inline in qlik and add that filed to filter for each report

Re: How to create filter in Nprintng For conditional as below.

arvind_patil — Thu, 05 Oct 2017 11:28:42 GMT

Hi Matus,

Firstly thanks for your reply. lets assume I have created filter A1

and apply it to U1 now how I remove it for Report 3

Thanks,

Arvind patil

Re: How to create filter in Nprintng For conditional as below.

arvind_patil — Thu, 05 Oct 2017 11:35:10 GMT

Firstly Thanks for your prompt responce ,

Now Suppose i have same user name as area manager just differnence is case sensitivity.

now how i can in filter you can add user and sepecif reports to see

Thanks,

Arvind Patil

Re: How to create filter in Nprintng For conditional as below.

mkelemen — Thu, 05 Oct 2017 11:55:08 GMT

Create filter B1 which has the field Area Manager with Override values flag. Add this filter to Report3.

Now you have this scenario from the help document:

User filter: Country = Italy, Germany (A1)
Report filter: Override values = Checked for Country (B1)
Resulting filter: Country = All countries

BR,

Matus

Re: How to create filter in Nprintng For conditional as below.

Chanty4u — Thu, 05 Oct 2017 12:14:37 GMT

if there is case sensitive issue,

you can add two field values .

or else you want same case ,....in Qlikside use the UPPER(Field) as NewFiled

and add this new field in the report/task

and follow the below Matus Kelemen steps

Re: How to create filter in Nprintng For conditional as below.

arvind_patil — Fri, 06 Oct 2017 05:59:35 GMT

Hi Matus & Chanty,

You both are correct.

I have create One Filed And pass it to individual user acoording to requirement.

Thanks,

Arvind Patil

Re: How to create filter in Nprintng For conditional as below.

Chanty4u — Fri, 06 Oct 2017 06:04:20 GMT

Nice please close the thread by making correct/Helpful answers above