topic Problem with a YearMonth filter in Qlik NPrinting

Problem with a YearMonth filter

mtabernad — Tue, 02 Mar 2021 09:43:56 GMT

Hi all,

I am trying to generate a report with the following filter: YearMonth = 202102. But it does not work. I also tried with YearMonth = '202102' and YearMonth = "202102". The other two filters works when I eliminate the YearMonth filter.

Does anyone know which should be the YearMonth filter format.

Thank you so much.

Re: Problem with a YearMonth filter

Lech_Miszkiewicz — Tue, 02 Mar 2021 10:31:34 GMT

Hi,

This can be very simple but it comes down to the method this field was created. Can you share the script which creates this field in Qlik Sense?

Depending on that datatype may be different. If it is traditional approach you would have script like:

Date(Floor(MonthStart(somedate)),'YYYYMM') as YearMonth

if that is the case then your filter should be numerical value of that date - (see link to my blog to learn what are the numerical representations of dates...)

If it is different then we have to know what it is otherwise we just guess it (same as you are at the moment)

the basics are also covered at https://help.qlik.com and I have written few posts about the most common issues with NPrinting filters which you can read here:

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/

Re: Problem with a YearMonth filter

Ruggero_Piccoli — Tue, 02 Mar 2021 10:36:25 GMT

Hi,

If the field is numeric you have to select "Numeric values is" in the dropdown menu instead of "Value is". Refer to https://help.qlik.com/en-US/nprinting/November2020/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-6.

Best Regards,

Ruggero