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