Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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!
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