topic Re: NPrinting 17 Excel Object Filter Not Working in Qlik NPrinting

NPrinting 17 Excel Object Filter Not Working

chriswain2 — Wed, 25 Sep 2019 18:40:54 GMT

Hi,

I have three copies of the same QlikView straight table where I have put date range filters on, in an Excel Report.

On the task I have another filter on different fields which definitely do not conflict.The individual fields have been put on the excel output, not the whole chart reference.

When I publish the task, the task filters work but all three straight tables come out the same, without the date filter.

Any ideas?

The only solution otherwise is to create 3 different tables in QlikView with the filters applied using set analysis, but this is time consuming and wastes memory.

Chris

Re: NPrinting 17 Excel Object Filter Not Working

Lech_Miszkiewicz — Thu, 23 Aug 2018 10:48:10 GMT

clearly your filters are not working.

My idea is you are not using filters correctly.

Would you mind sharing screenshots of:

field in qlik you use to filter it (with data type like info whether it is acsci text, date, integer, numeric etc...)
screenshot of your filters in NPrinting

The main thing around filters in nprinting is that dates usually need to be floored and used as numerical values like: 43XXX.. instead of date format...

Re: NPrinting 17 Excel Object Filter Not Working

chriswain2 — Thu, 23 Aug 2018 11:04:57 GMT

Hi Lech,

I have found out a few things since I posted. I can rule out dates as an issue because the field I am filtering is not a date field, it is an ageing bucket field.

It is nothing to do with the task filters as it does not work on the edit template preview, before any task filters are applied.

I am using a dual value field and using "value is = 0-30"

Maybe I have to use numeric value = 1 or does Nprinting not like dual value fields at all.

I will do more testing on that.

Regards,

Chris

Re: NPrinting 17 Excel Object Filter Not Working

Lech_Miszkiewicz — Thu, 23 Aug 2018 11:08:24 GMT

Dual values need to be filtered as numerical values!!

I have posted few examples on community regarding this.

Re: NPrinting 17 Excel Object Filter Not Working

chriswain2 — Thu, 23 Aug 2018 11:15:10 GMT

Thanks Lech,

I did search before posting but did not see that. Will mark as correct answer as soon as I get it working.

Chris

Re: NPrinting 17 Excel Object Filter Not Working

chriswain2 — Thu, 23 Aug 2018 11:25:39 GMT

All working now.

Just a point to note - when you have a dual field and are typing the values in, the autofill suggestions show the text values even when you select "numeric value is" - see attachment. This is a bit misleading and would have stopped me making this mistake if it had showed the valid numeric values only.

Chris