Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
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
Daniel_Jenkins
Support
Support

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.

View solution in original post

2 Replies
Daniel_Jenkins
Support
Support

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.

View solution in original post

hopkinsc
Partner
Partner
Author

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