Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

tom2qlik
New Contributor III

OR Operator as Filter in Nprint

Hi All,

I have three filters I want to apply to an NPrint job.

I'm wondering is it possible to apply an AND + OR operator between these two filters?

Filters look like:

(Level = 1

and Status = Live)

OR

Status = Delayed

I haven't found anything regarding it on the community.

Thanks,

Tom

1 Solution

Accepted Solutions
Employee
Employee

Re: OR Operator as Filter in Nprint

Hi Tom,

In NPrinting you can create a filter with Level = 1 and Status = Live, another filter with Status = Delayed but when you add both NPrinting filters to a report the operator is an AND and it is not possible to transform it into an OR.

Workarounds could be:

- create a new field in the reload script that is true when the condition is verified and create the NPrinting filter based on this new field

- create a new chart that shows only the data rows that satisfy the condition. Note that NPrinting supports hide charts saved on visible sheets.

In both cases you need to modify the data source.

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.
1 Reply
Employee
Employee

Re: OR Operator as Filter in Nprint

Hi Tom,

In NPrinting you can create a filter with Level = 1 and Status = Live, another filter with Status = Delayed but when you add both NPrinting filters to a report the operator is an AND and it is not possible to transform it into an OR.

Workarounds could be:

- create a new field in the reload script that is true when the condition is verified and create the NPrinting filter based on this new field

- create a new chart that shows only the data rows that satisfy the condition. Note that NPrinting supports hide charts saved on visible sheets.

In both cases you need to modify the data source.

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.
Community Browser