topic Re: How do you create a filter to compute current month? in Qlik NPrinting

How do you create a filter to compute current month?

Thu, 18 Feb 2016 21:45:41 GMT

In Nprint, how do you write a filter to pull in just the current month?

I've tried value of month(now()) but does not compute.

Re: How do you create a filter to compute current month?

Nicole-Smith — Thu, 18 Feb 2016 22:52:36 GMT

Is your month field an integer? If so, month(now()) is returning a string ("Feb"), but num(month(now())) will return an integer. You would set up the NPrinting filter like this:

Re: How do you create a filter to compute current month?

Fri, 19 Feb 2016 14:45:30 GMT

Thank you, this works! I just have to modify the formula to adjust to our fiscal calendar now.

Should have posted here sooner!