topic Re: Conditional Date Range Filter in Qlik NPrinting

Conditional Date Range Filter

StefanE — Mon, 19 Apr 2021 11:36:52 GMT

Good Day,

If this topic has already been discussed I apologize.

I'm new to Nprinting and do want to create a dynamic filter for automisation purposes.

The following shall be expressed:

If the current day of the month is greater than 20, then show me/select all months from the start of the year until last month, else then show me/select all months from the start of the year until second to last month.

E.g., on the 22nd of April, the months January until March shall be shown. On the 1st of Mai, the the months January until March shall be shown as well until the 20th of Mai and so on.

Any ideas how and where (Advanced Search?) to approach this issue? Do you need more info?

Btw.: I cannot change the script, so I can't flag the months.

Thanks in advance and kind regards

Stefan

Re: Conditional Date Range Filter

Ruggero_Piccoli — Mon, 19 Apr 2021 12:52:32 GMT

Hi,

There are some similar examples that uses Advanced Search at:

My suggestion is to first develop the advanced search directly in the source Qlik Sense app then copy the formula in a Qlik NPrinting filter.

Refer to https://help.qlik.com/en-US/nprinting/February2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-9 I also suggest to read the whole page about filters.

I hope this helps.

Best Regards,

Ruggero

Re: Conditional Date Range Filter

StefanE — Tue, 20 Apr 2021 07:08:30 GMT

Hi Ruggero,

Your approach totally worked for me. I tweaked it a little bit with an if statement:

=if(day(today())>19, [YearMonth]<=(year(addmonths(today(), -1)))*100 + MONTH(addmonths(today(), -1)), [YearMonth]<=(year(addmonths(today(), -1)))*100 + MONTH(addmonths(today(), -2)))

Thanks so much for your support!

Kind regards

Stefan

Re: Conditional Date Range Filter

Ruggero_Piccoli — Tue, 20 Apr 2021 08:14:23 GMT

Hi,

Happy to hear that you solved. Thanks for sharing the solution in the community: it will be a useful example for other readers.

Best Regards,

Ruggero