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: 
Anonymous
Not applicable

Filter question Nprinting 17 for Qlik Sense

Can filters in Nprinting be set for either:

1. Not equal

2. OR

Ex:

1. ProductCategory not equal 'Produce'

2. Role = 'Management' OR Status = 'Deleted'

Looking specifically for nprinting filter capability from the App section of the website rather than set analysis, filters table level within a report, or other for example.

Would greatly appreciate any info here. Thanks.

Ken

1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

Hi,

1 - No. If the number of distinct values in the field you want to filter is limited you can create a list (item-by-item) of the values you want to keep. An alternative is to create a calculated column in the reload script with a formula that assign the value 1 on the rows you want to keep and 0 in the other and then filter this field.

2 - Same workaround. Create a calculated column that is true when the condition is met.

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

1 Reply
Ruggero_Piccoli
Support
Support

Hi,

1 - No. If the number of distinct values in the field you want to filter is limited you can create a list (item-by-item) of the values you want to keep. An alternative is to create a calculated column in the reload script with a formula that assign the value 1 on the rows you want to keep and 0 in the other and then filter this field.

2 - Same workaround. Create a calculated column that is true when the condition is met.

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.