Skip to main content

Qlik NPrinting

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
KHSDM
Creator II
Creator II

Greater Than Filter (Nprinting Nov 2018)

I'm trying to filter my Nprinting report based on due date greater than today. How can I do it in Nprinting Nov 2018? Is it supported? I'm using Excel format.

Labels (1)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

Currently NPrinitng does not support such filters.

As a workaround you need to flag records in your Qlik datamodel for those which are greater than today and use flag as a filter in NPrinting.

so... in your load script you would have: If(duedate > today(),1,0 ) as flag

and in NPrinitng you would use filter: flag: numeric value is: 1

 

cheers

Lech

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

4 Replies
Lech_Miszkiewicz

Currently NPrinitng does not support such filters.

As a workaround you need to flag records in your Qlik datamodel for those which are greater than today and use flag as a filter in NPrinting.

so... in your load script you would have: If(duedate > today(),1,0 ) as flag

and in NPrinitng you would use filter: flag: numeric value is: 1

 

cheers

Lech

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
KHSDM
Creator II
Creator II
Author

I see... hopefully this type of filtering will be supported in the future.
Giansonn
Creator
Creator

I have tried all kinds of excel tricks to filter on dates in the editor but nothing works.

If anyone knows a way to filter in the excel editor let me know!

Lech_Miszkiewicz

Hi @Giansonn,

I dont understand your query.. What do you mean by Excel editor. Filtering of NPrinting is not done in designer its always done via filters which you configure in NPrintgin admin console. 

More on the actual >=, >,<=,< filters you can find in this bog: https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

official documentation which I encourage you to study you can find on https://help.qlik.com

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.