topic Re: Nprinting Filter in Qlik NPrinting

Nprinting Filter

Eduard23 — Mon, 28 Nov 2022 09:54:02 GMT

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

Re: Nprinting Filter

Ruggero_Piccoli — Mon, 28 Nov 2022 13:28:53 GMT

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-filters.htm#anchor-8 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

Re: Nprinting Filter

Eduard23 — Tue, 29 Nov 2022 11:26:16 GMT

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