Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

daniel_sanchezm
Contributor

Nprinting doesn't insert all rows into Excel

Hi everyone.

I´m using Nprinting to distribute Excel reports. I´m usig filters to send the information but Nprinting doent insert all rows into Excel.

Suppose that after applying filter in QlikView the result is one pivot table with 12 rows and after receiving the email and open the excel file only shows 11 rows. No matter if I change the filter value, Nprinting always attach an excel file without one row.

Is it a configuration issue or is it a Nprinting Bug?

Sorry but I cannot contact the Qlik Support Desk because I'm not able to login

1 Solution

Accepted Solutions
daniel_sanchezm
Contributor

Re: Nprinting doesn't insert all rows into Excel

Hi Vasim,


You have to check the Show Totals options at the table properties.

I hope this can help you

14 Replies
Not applicable

Re: Nprinting doesn't insert all rows into Excel

are you saying that there is a difference of one row between the pivot table in Qlikview and the pivot table in nprinting

when you bring in a pivot table into nprinting it does not format it as a true pivot table - could that be the reason

is there a row of data always missing - is it the first row, last row?

can you post a sample of the qv pivot and the np pivot

The data should match - the format/layout may look a little different

Not applicable

Re: Nprinting doesn't insert all rows into Excel

daniel - your other psot says you atached the xslx and the table but did not see any attachments

Not applicable

Re: Nprinting doesn't insert all rows into Excel

if you make a copy of your pivot table in Qlik and make it a straight table and use the straight table in Nprinting, do you get the same number of rows?

daniel_sanchezm
Contributor

Re: Nprinting doesn't insert all rows into Excel

Hi Adam,

I change to straight table but I get different number of rows.

QV Straight Table

QV_FV.jpg

NP XLSX Table

NP_XLSX_FV.jpg

NP CSV Table

NP_CSV_FV.jpg

Only when NP export to XLSX there is one missing row

Not applicable

Re: Nprinting doesn't insert all rows into Excel

can you send the nprinting and qv pivot table?

it looks like qv straight table and np csv have the same but it looks like nprinting xlsx is missing the row where the first column is 200?

how are you creating the table in npringing?

in the template are you dragging the entire table or doing it column by column?  any formulas or other objects on the template?

Have not seen this before and I use table in Excel quite a bit

can you scramble the data and post the qvw and nsq?

Not applicable

Re: Nprinting doesn't insert all rows into Excel

also, have you tried pointing to one of the training qvw that Qlik provides and see if you have the same issue?

do you have calcualted dimensions?

Not applicable

Re: Nprinting doesn't insert all rows into Excel

Daniel - any new info on this?

Not applicable

Re: Nprinting doesn't insert all rows into Excel

Daniel

how is it going?

any new information you can provide regarding this issue?

zeeshanadeel
New Contributor III

Re: Nprinting doesn't insert all rows into Excel

NPrinting creates an image of Pivot table. I believe if you resize the Pivot table in Qlikview/NPrinting that would resolve the issue.

I always refrain myself creating NPrinting pivot excel file because I don't like it as image.

Cheers!

Community Browser