Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lauranvh
Partner
Partner

Multiple user filters NPrinting 17

Hello people,

I have a problem with User Filtering in NPrinting 17.One user can have more than 1 filter on the same dimension. When i run the report in NPrinting i get a Empty set warning

I'm importing users/filters/groups via the Excel document. Now I made a couple filters that I attached to users.

For example:

User Qlik has 2 filters on Country:

     Filter1 : [Country] = {"Germany"}

     Filter2 : [Country] = {"France"}

When I run this report I ge tthe Empty set warning.

When I combine the filter in one filter I don't get this error, but the filters are used for more than one user so they have to be separate.

For example

User Qlik has 1 filter on Country:

     Filter12 : [Country] = {"Germany", "France"}

How can I fix this?

1 Solution

Accepted Solutions
Ruggero_Piccoli
Employee
Employee

Hi,

Applying

     Filter1 : [Country] = {"Germany"}

     Filter2 : [Country] = {"France"}

to a user means that Country must be Germany AND France at the same time. That of course is false so you will get an empty dataset.

If you apply:

     Filter12 : [Country] = {"Germany", "France"}

to a user it means that Country could be Germany OR France so you will have a dataset with something inside.


In your scenario you have to create a filter for each user at least some users have the same filters but you cannot create F1 end F2 and apply them with a logical OR connection.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT. 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.




Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

5 Replies
Chanty4u
MVP
MVP

can you share the filter screen shot in nprinting?

lauranvh
Partner
Partner
Author

Ofcourse.

The example is like the 4 screenshots i made.

The 3 filters:

FiltersExample.png

The user I made the examples for:

UserExample.png

The filters in NPrinting Web Console look like this:

The first screenprint doesn't work. That way the user gets two of these filters on his name and the task gives back a empty response.

Filter1Print.png

FilterPrint.png

Ruggero_Piccoli
Employee
Employee

Hi,

Applying

     Filter1 : [Country] = {"Germany"}

     Filter2 : [Country] = {"France"}

to a user means that Country must be Germany AND France at the same time. That of course is false so you will get an empty dataset.

If you apply:

     Filter12 : [Country] = {"Germany", "France"}

to a user it means that Country could be Germany OR France so you will have a dataset with something inside.


In your scenario you have to create a filter for each user at least some users have the same filters but you cannot create F1 end F2 and apply them with a logical OR connection.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT. 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.




Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

lauranvh
Partner
Partner
Author

Thanks for your reply.

Clearly I thought filters worked differently.

Going to have to think of a different solution for my problem.

ssaddepal
Contributor III
Contributor III

How are you relating these filters to users ? based on your data model ?

If user1 is assoicated with countries France and India and the corresponding filter should be {"France", "India"}

and if user2 and user 3 are associated with France and the corresponding filters for them should be {"France"}.

If the above is your usecase, why don't you just prepare your filters in the qvw/qvf itself using 'Filter={'&chr(34)Country&chr(34)&'}'..something like this. Then only the associated filters would come up to each user.

Otherwise, as rpc‌ pointed out, and and logic won't work as when you specify filters seperated by commas, its doing exactly that.