Nprinting Filter

[Eduard23]

Hi All ,

Currently We have new Fiscal Period and Fiscal year Settings

The Fiscal Period is same as the monthly period except have different range 

Example Fiscal Period

1 = the first month  which will be January 1 to January 24

2 = 2nd month which will be January 25 to February 24

3 = 3rd month which will be February 25 to March 24 so on except for December

12= 12 month which will be November 25 to december 31

We already have the filter for it but the problem is i need to do it in Nprinting so report will be broadcast via monthly fiscal period, for now what i did is create a filter just put the current fiscal month and year , i just update it monthly, but it is very hard i might forget to update it. Please help

[Ruggero_Piccoli · Accepted solution]

Hi,

You can create dynamic filters by using formulas instead of fixed values https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Static-dynamic-fi... and, maybe, you already have the formula to calculate the fiscal period in the reload script of the Qlik Sense app. Note that you have to use Qlik Sense formulas.

Best Regards,

Ruggero

[Eduard23]

Hi ok, i will test it, for the formula honestly don't have it yet. Need to test