topic Re: NPrinting Report 'levels' function - how do I filter out null values? in Qlik NPrinting

NPrinting Report 'levels' function - how do I filter out null values?

craggus — Thu, 02 Apr 2020 10:26:42 GMT

Morning,

I am trying to set up a basic Nprint report which shows all invoices generated per customer... in order to do this I have added a Level into the report.

When the report runs, it includes ALL customers even those that have no sales / invoices.

The source table in Qlik Sense is set to ignore null values, so only those customers with sales / invoices are displayed. How do I replicate this in the NPrinting report, so that customers with no sales / invoices are ignored? I cannot find any Nprinting options to enable me to do this.

Thanks

Craig

Re: NPrinting Report 'levels' function - how do I filter out null values?

lironbaram — Thu, 02 Apr 2020 12:00:36 GMT

instead of using the field in the level ,

you can use a table in the level

the table should have the customer as dimension and and expression that makes sure you only display the relevant customers

or you can create a filter on the field customer which filter only relevant customers you

advanced search capabilities

Re: NPrinting Report 'levels' function - how do I filter out null values?

craggus — Thu, 02 Apr 2020 14:09:02 GMT

Thanks for the quick reply, I'll take a look into that now.
What do you mean by "advanced search capabilities" ?

Re: NPrinting Report 'levels' function - how do I filter out null values?

lironbaram — Thu, 02 Apr 2020 16:02:19 GMT

it means you can create advanced filters like

in customer field you can use "=sum(sales)>10000" and only get customers who's sales amount is larger then 10,000

Re: NPrinting Report 'levels' function - how do I filter out null values?

Lech_Miszkiewicz — Fri, 03 Apr 2020 00:31:30 GMT

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

Re: NPrinting Report 'levels' function - how do I filter out null values?

craggus — Fri, 03 Apr 2020 14:03:01 GMT

Lironbaram - your suggestion to use a table in the level (rather than the customer field) worked perfectly, thanks very much!

Craig