Conditional Date Range Filter

[StefanE]

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

[Ruggero_Piccoli · Accepted solution]

Hi,

There are some similar examples that uses Advanced Search at:

• https://community.qlik.com/t5/Qlik-NPrinting-Discussions/error-in-filter/td-p/1799765
• https://community.qlik.com/t5/Qlik-NPrinting-Discussions/filter-of-a-range-of-date/td-p/1799902

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-dynam... I also suggest to read the whole page about filters.

I hope this helps.

Best Regards,

Ruggero

[StefanE]

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

[Ruggero_Piccoli]

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