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: 
Dharanidharan_DD

Date Filters

Hi Guys .

Suggest me a dynamic Filters in nprinting to select..

1) yesterday (using fiscal year)

2)  Previous Month ( using fiscal year)

3) year of yesterday, month of yesterday  (using fiscal year)

4) weekly filters to select last 7 days..

 

 

@Ruggero_Piccoli 

 

 

 

Labels (2)
2 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

There is no one right solution for this. There are few... for example:

  • My favourite is to create flags in load script for those periods. 
  • or you can use advanced search option to reference today or yesterday against the fiscal periods in your fiscal calendar. This approach depends on how you have structured your fiscal calendar in your data model. Usually I have regular calendar fields and fiscal calendar fields in one table which you can use in set analysis of advanced search filters

similar concepts I have described here:

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

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.
Ruggero_Piccoli
Support
Support

Hi,

I agree with @Lech_Miszkiewicz :

- flags in the load script have the advantage that you calculate their values only one time when you reload the data. This means that no calculations are needed (or at least less calculation) when Qlik NPrinting applies the filters so you will see a faster reports generation time.

- advanced filtering uses the QlikView/Qlik Sense syntax so you have to refer to it to implement your specific selections

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.