Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
IMPORTANT: PLEASE READ - Labels will be required in the NPrinting forum starting on Friday September 26, 2019: Click here for details and instructions.
Partner
Partner

NPrinting Filter >0

Hey guys,

I am struggling to get a filter to work in NP - version Sep 2018.

Its a basic filter, all i want to do is make a selection on a field greater than 0 (zero).

Its a field that holds sales qty, there are negatives in the field (where returns have been processed), so i only want to see the values that are greater than 0

I have tried

Evaluate Value 

>0

=>0

=if(Sales>0,Sales)

 

Value is

>0

=>0

 

Can anyone help please?

1 Solution

Accepted Solutions
Support
Support

Re: NPrinting Filter >0

Hi,
NPrinting 17.x/18.x does not (yet) have options to filter based on Variables, Bookmarks and Advanced Search (which is what you are trying to do). Perhaps you could flag the records that have Sales > 0 in the load script and use that flag in your NPrinting filter?

HTH - Daniel.
2 Replies
Support
Support

Re: NPrinting Filter >0

Hi,
NPrinting 17.x/18.x does not (yet) have options to filter based on Variables, Bookmarks and Advanced Search (which is what you are trying to do). Perhaps you could flag the records that have Sales > 0 in the load script and use that flag in your NPrinting filter?

HTH - Daniel.
Partner
Partner

Re: NPrinting Filter >0

Thanks Daniel, I have added some set analysis in the chart instead of trying to use NP to do the selection.