topic Re: Generate Empty NPrint report there is no data. in Qlik NPrinting

Generate Empty NPrint report there is no data.

Ramu_i — Thu, 23 May 2024 09:24:44 GMT

Hi team,

I have a NPrint report here I applied filters like Product =2, If Product is 2 then will generate the Excel report, If there is no product 2 values in data in this case empty report generate.

If Product is 2 , NPrint report is generating fine , But there is no values for Product 2 report generation is failed.

Could you please help on that.

Advance thanks

Ram

Re: Generate Empty NPrint report there is no data.

Lech_Miszkiewicz — Thu, 23 May 2024 10:29:58 GMT

Hi,

If you wish to produce empty report for particular selection in first place you need to ensure that you are able to apply required filters.

For your scenario you need to make sure you always have ability to apply Product filter even when there is no factual data. In real life it means that in your Qlik sense app you need to creaty combinations of required dimensions with no fact data and concatenate that to your fact table. If there is combination of few filters make sure you create a cartesian product of such filters and concatenate them in.

cheers

Lech

Re: Generate Empty NPrint report there is no data.

David_Friend — Thu, 23 May 2024 18:55:12 GMT

@Lech_Miszkiewicz has answered this question previously:

https://community.qlik.com/t5/Qlik-NPrinting/Can-NPrinting-generate-an-empty-report-if-it-cannot-apply-a/td-p/2029075

Re: Generate Empty NPrint report there is no data.

Ramu_i — Fri, 24 May 2024 04:41:19 GMT

Hi Lech_Miszkiewicz,

Thanks for replay.

Product column is there in that Prod_1, Prod_2,Prod_3, Prod_4 these are the values.

In Nprtint report format is excel. Here we have selected table data.

I have applied product filter, When NPrint generate it will shows the Prod_2 information.

If data level there is no prod_2 data in this case it will be show empty report. Product column having Prod_1, Prod_3 and Prod_4 data. Prod_2 data is not there.

If there is no data for particular value, report will show empty, If data is there will show the data.

Ex:-

Data

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

Product City Sales Quantity

Prod_1 US $100 4

Prod_2 US $120 10

Prod_3 US $140 2

Prod_4 US $80 5

Required Out Put:

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

Product City Sales Quantity

Prod_2 US $120 10

If Data have in this way

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

Product City Sales Quantity

Prod_1 US $100 4

Prod_3 US $140 2

Prod_4 US $80 5

Required Out Put

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

Product City Sales Quantity

Thanks

Ram

Re: Generate Empty NPrint report there is no data.

Lech_Miszkiewicz — Fri, 24 May 2024 05:23:58 GMT

Hi @Ramu_i

yes - but for it to work you need to make sure you prepare your data first in Qlik Sense so it is loaded like this:

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

Product City Sales Quantity

Prod_1 US $100 4

Prod_2 US

Prod_3 US $140 2

Prod_4 US $80 5

Then output will be like this:

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

Product City Sales Quantity

cheers

Lech