Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
arvind_patil
Partner - Specialist III
Partner - Specialist III

How to create filter in Nprintng For conditional as below.

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

10 Replies
Chanty4u
MVP
MVP

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

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

How  could explain little bit more.

mkelemen
Creator III
Creator III

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

Chanty4u
MVP
MVP

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

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

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

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

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

mkelemen
Creator III
Creator III

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

Chanty4u
MVP
MVP

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

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

Hi Matus & Chanty,

You both are correct.

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

Thanks,

Arvind Patil