dynamic filter which returns the values differents of zero

[paolakamdem]

hello everyone 

i would like to create a filter in Nprinting which returns the values different of zero.

i have already tried with evaluate value is >0 but it returns nothing

thanks in advance.

[Ruggero_Piccoli · Accepted solution]

Hi,

In Qlik NPrinting 17+ filters like this (greater then and similar) are not supported at the moment (November 2018). As answered in other similar posts here the best solution is to add a calculated field in the script of the source Qlikview document or Qlik Sense app that is true if the value you want is greater than zero and then add a  Qlik NPrinting filter in the new field.

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.

[Frank_S]

Ruggero's comment is correct.
See the following link regarding the use of a filters which attempts to calculate an array of values.
Doing so will result in a '-' output.

"Formulas used in Qlik NPrinting must evaluate to a unique value."

See link below for more information:
https://help.qlik.com/en-US/nprinting/September2018/Content/NPrinting/ExcelReports/Formulas.htm

[JonnyPoole · Accepted solution]

Could you add a field in your data model ? 

Instead of 

Load * Inline [

Values

0

100

50

0]; 

Add a calculated field that distinguishes the values with a boolean flag

Load

*,

if( Values = 0, 'Zero','GreaterThanZero') as Flag

Inline [

Values

0

100

50

0]; 

and then make your filter  Flag='GreaterThanZero'