topic Re: Current Month Filter in Qlik NPrinting

Current Month Filter

KHSDM — Sat, 16 Nov 2024 04:30:01 GMT

Hi all,

I have a month field in my QVW, and I want to filter it in Nprinting to the current month. I've created a filter with that field and use the evaluate option, but I keep getting error when I run the task. It works if it is just the current year field.

What could be the cause of the error?

Re: Current Month Filter

pradosh_thakur — Mon, 11 Feb 2019 08:05:45 GMT

Do a quick check please.

1: Just put the MonthName values as Feb once and run
2: Just put the MonthName values as 2 once and run

Let us know if this generates error.

Re: Current Month Filter

KHSDM — Mon, 11 Feb 2019 08:29:04 GMT

Hi Pradosh,
It works if I put it as ='Feb'
It doesn't work if I put is a =2

Re: Current Month Filter

pradosh_thakur — Mon, 11 Feb 2019 09:09:39 GMT

Try =text(Month(Today())) as evaluate value. I think it should work.