Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

hopkinsc
Valued Contributor II

Pixel perfect table

Hi all,

i am having trouble trying to get a table in a pixel perfect report within a level (QlikView to NP17.3.1)

basically i have a level which splits the data by 'Customer', within this level i have created a bar chart showing sales by dept. up to this point works as expected, i get a 10 page report, each page for a different customer displaying the department sales relating to that customer.

I am now trying to add in a table which shows the top 10 selling products. this also needs to go on each page which is split by customer so it only shows the data for the particular customer that is on that page.

I cant get this to work at all, i'm sure its something i am doing wrong but if anyone could offer any help that would be great.

here is a screenshots of my template..

Capture.JPG

and a screenshot of the output..

Capture1.JPG

as you can see only 1 row is appearing, it is being split correctly by the customer level though but there are 10 rows in the table in QV.

how do i get all rows into the report?

any help would be appreciated.

8 Replies
hopkinsc
Valued Contributor II

Re: Pixel perfect table

bump

prachisangewar
Contributor

Re: Pixel perfect table

Hi,

The report has exceeded the size limit,can you try to shrink the size of the objects or may be move the Chart to next page

hopkinsc
Valued Contributor II

Re: Pixel perfect table

Hi Prachi,

why do you say that its exceeded the size limit?

on the output there is a quarter of the page left (blank) and all i want is the additional 9 rows.

I have tried moving the bottom page break and margin down but it makes no difference, i only get 1 row of data.

prachisangewar
Contributor

Re: Pixel perfect table

What I understood is it goes to the bottom of the page and shows last row.

Can you try to create an excel output  and see if the same happens?

Also, for pixel perfect can you try to reduce the 100% (on the second screen above) to around 70% and see what is the change ?

Re: Pixel perfect table

Hi Chris, I think that the product table will need another level by product so it iterates and shows a line by each product.

hopkinsc
Valued Contributor II

Re: Pixel perfect table

Hi Ruben,

how do i go about adding another level within a level?

Re: Pixel perfect table

As I remember it was only rigth-click on the first level (customer level in your case) and select the option to add another level.

If my idea is correct the chart and the header of the product table will go above the new sub-level and the product lines inside the new level level

I have searched a similar example in the NPrinting help:

https://help.qlik.com/en-US/nprinting/17.3/Content/PixelPerfectReports/How%20AddTotalsSubtotalsPixel...

In video:

Video Link : 3029

hopkinsc
Valued Contributor II

Re: Pixel perfect table

thanks Ruben,

i can't get it to work so i have reverted to excel instead of PixelPerfect.

Community Browser