topic Filters not working in Qlik NPrinting

Filters not working

baarathi — Sat, 16 Nov 2024 04:28:46 GMT

I have a NPrinting Excel Report Template, I have applied filter on fields Company Name and MonthYear filters.

Field1: Company - Asant

Field2: MonthYear - 2018-Dec

The Company filter works fine. But the MonthYear filter does not seem to get applied?

Re: Filters not working

pradosh_thakur — Tue, 12 Feb 2019 14:18:37 GMT

Is your month year date or string? you might need to use the evaluate option to make it work. How does your MonthYear looks like?

Re: Filters not working

baarathi — Tue, 12 Feb 2019 14:29:12 GMT

@pradosh_thakur Hi Pradosh,

My MonthYear Field has values in this format 'Dec 2018'

Re: Filters not working

pradosh_thakur — Tue, 12 Feb 2019 14:32:43 GMT

try below

1: add Dec 2018 as a string and check if you are getting the output

2: add date#('Dec 2018','MMM YYYYY') as the evaluate option.

Let us know if any of above works

Re: Filters not working

Frank_S — Tue, 12 Feb 2019 14:34:34 GMT

If your month year field is actually a 'dual' then you need to use 'numeric value is' rather than 'value is' when creating/configuring the filter in NPrinting. It could be that the data is numeric even if it appears as alphanumeric.

Re: Filters not working

baarathi — Tue, 12 Feb 2019 20:50:03 GMT

@Frank_S Thank You.

Re: Filters not working

baarathi — Tue, 12 Feb 2019 20:51:13 GMT

thank you