topic Re: NPrinting Filter in Qlik NPrinting

NPrinting Filter

fcecconi — Fri, 03 Aug 2018 19:41:38 GMT

I am creating an Excel based report in NPrinting. I only want to show the rows where a column value is null. How do I do this in a filter?

thanks

Frank

Re: NPrinting Filter

wade12 — Fri, 03 Aug 2018 19:47:17 GMT

filters can be dynamic or static.

here is the official qlik video to demonstrate filters:

Creating static and dynamic filters - Qlik NPrinting - YouTube

best wishes.

Re: NPrinting Filter

fcecconi — Fri, 03 Aug 2018 19:54:18 GMT

Thanks, but that doesn't show how to handle exactly what I am looking for. I only want if the field is null. I have tried using ='' and Isnull

Both didn't work

Re: NPrinting Filter

wade12 — Fri, 03 Aug 2018 20:05:17 GMT

isnull() should work.

it might not be reading the correct data type.

try not(isnull()) to see if it gives the result you would expect.

if not, then you may have to re-format the data type.

Re: NPrinting Filter

fcecconi — Fri, 03 Aug 2018 20:43:48 GMT

I tried both in the evaluate option and neither worked.

Re: NPrinting Filter

Lech_Miszkiewicz — Fri, 03 Aug 2018 23:07:06 GMT

Are you guys serious?

Were you ever able to select "Null" in QlikView or Qlik Sense simply on the front end (from listbox)? Of course NOT!!!

NPritnign works exactly the same, so you will not be able to do this via simple selection. First you have to flag those records in the load script of your application. I am aware that it might not be easy but 90% of time it can be done on the required level. Once you have your flag created you can use this flag as a filter in Nprinitng.

regards

Lech

Re: NPrinting Filter

wade12 — Sat, 04 Aug 2018 10:18:23 GMT

thanks lech.

can use len() when creating flags in script.

Re: NPrinting Filter

Lech_Miszkiewicz — Sun, 05 Aug 2018 23:27:01 GMT

Hi Wade,

It all depends in your model. The biggest challenge is to have right level of aggregation (similar to the one used on front end in NPrintign report as well as dimensions and measures sitting in the same table as only then you can run a proper check if value is null.

Yes you could use len() function in script to run your checks and create flags. My usual approach is If(Len(trim(field))>0, 0,1) as FlagIsNull

Re: NPrinting Filter

wade12 — Mon, 06 Aug 2018 10:01:01 GMT

hi lech, you are correct, thanks.

Re: NPrinting Filter

fcecconi — Mon, 06 Aug 2018 12:50:58 GMT

Let me update. Without redesigning the application the null is being created in the table due to no value in 1 table (this is correct). I want to filter the table in NPrinting to only show those records with the null exists. This indicates new records.

Re: NPrinting Filter

Ruggero_Piccoli — Tue, 07 Aug 2018 08:57:17 GMT

Hi,

As lech_miszkiewicz‌ told, it is not possible to select NULL explicitly in QlikView or in Qlik Sense. Qlik NPrinting does the same operations you manually do, so if a feature is not available originally in QlikView or Qlik Sense it is also not available in Qlik NPrinting.

There are many posts in the community with suggestions about how to manage the NULL but at the end the best solution is to create a flag as showed by Lech.

For example refer to:

- NULL handling in QlikView‌ (select expluded and advanced search are not yet available in Qlik NPrinting 17+)

- Selecting Null values in a Filter

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: NPrinting Filter

wade12 — Tue, 07 Aug 2018 09:00:47 GMT

thanks ruggero.