Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

ken_flynt
New Contributor

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
Employee
Employee

Re: Filter question Nprinting 17 for Qlik Sense

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.

1 Reply
Employee
Employee

Re: Filter question Nprinting 17 for Qlik Sense

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.

Community Browser