Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
fernfrancis
Contributor
Contributor

Qlik nprinting filter help

Hi Team,

 I have generated a report using qlik nprinting and its working perfectly  the only issue is that the size of the report is large and i need to restrict this report to the last 48 hours so that its less. 

The column available it  timestamp and it contains the data as " 2017-08-20 12:00:43" . 

If someone can help me with this requirement. 

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi 

  1. first of all NPrinting 16 does not work with Qlik Sense so label you choose is clearly wrong. What is the exact version of NPrinting you are using?
  2. second of all - try not to duplicate posts - the same question was asked just few posts below yours: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/qlik-nprinting-solution-for-date/td-p/19736... and contains anser to your question

in summary - use advanced search filter to do that! with function "=now()-2". This obviously will only work if your field is indeed of numerical, date, timestamp type in Qlik Sense. 

more on that on my blog: 

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

 

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

1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi 

  1. first of all NPrinting 16 does not work with Qlik Sense so label you choose is clearly wrong. What is the exact version of NPrinting you are using?
  2. second of all - try not to duplicate posts - the same question was asked just few posts below yours: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/qlik-nprinting-solution-for-date/td-p/19736... and contains anser to your question

in summary - use advanced search filter to do that! with function "=now()-2". This obviously will only work if your field is indeed of numerical, date, timestamp type in Qlik Sense. 

more on that on my blog: 

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

 

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.