Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

anindya_manna
Contributor II

How to remove blank pages from Nprinting output while paging applied

Hi Expert,

I am creating a Nprinting output of a report in excel format.I have applied paging option by a particular field.But in the chart that particular field values not present entirely.Few value missing.Thats why in Nprinting few pages are blank.Any idea how to remove those pages?

Header 1Header 2Header 3Header 4
1aaa500
2baa100
3cbb200

For an eaxmple I am creating the pages based on Headr2 column which have values in DB a,b,c,d,e,f but in chart only a,b,c is there so for d,e,f, blank pages are generated.I dont have any scope to add any column in data model.

Please help

Tags (2)
1 Reply
gngijben
New Contributor III

Re: How to remove blank pages from Nprinting output while paging applied

Hi, I had the same problem. How I fixed it:

I was using CUSTOMER_NAME as page and revenue as measure in a table. But some customers had no revenue resulting in a blank page. Solution in my case: Left Keep on the customer dimension to the fact table. That way you drop the customers who have no revenue and you can get rid of the blank pages.

Community Browser