topic Re: Nprinting doesn't insert all rows into Excel in Qlik NPrinting

Nprinting doesn't insert all rows into Excel

Anonymous — Thu, 17 Dec 2015 00:10:51 GMT

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

Re: Nprinting doesn't insert all rows into Excel

Thu, 17 Dec 2015 14:08:18 GMT

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

Re: Nprinting doesn't insert all rows into Excel

Thu, 17 Dec 2015 14:09:53 GMT

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

Re: Nprinting doesn't insert all rows into Excel

Thu, 17 Dec 2015 14:37:40 GMT

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?

Re: Nprinting doesn't insert all rows into Excel

Anonymous — Thu, 17 Dec 2015 16:40:51 GMT

Hi Adam,

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

QV Straight Table

NP XLSX Table

NP CSV Table

Only when NP export to XLSX there is one missing row

Re: Nprinting doesn't insert all rows into Excel

Thu, 17 Dec 2015 16:47:29 GMT

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?

Re: Nprinting doesn't insert all rows into Excel

Thu, 17 Dec 2015 16:51:59 GMT

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?

Re: Nprinting doesn't insert all rows into Excel

Thu, 17 Dec 2015 18:55:57 GMT

Daniel - any new info on this?

Re: Nprinting doesn't insert all rows into Excel

Fri, 18 Dec 2015 17:49:43 GMT

Daniel

how is it going?

any new information you can provide regarding this issue?

Re: Nprinting doesn't insert all rows into Excel

zeeshanadeel — Tue, 12 Jan 2016 20:12:25 GMT

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!

Re: Nprinting doesn't insert all rows into Excel

chaudhariv — Thu, 21 Jul 2016 20:18:00 GMT

Hi Daniel,

Did you get any solution to this...I am also facing the same issue.

Last line of my straight table is missing where as the some different pivot table show all records fine.

Thanks

Re: Nprinting doesn't insert all rows into Excel

Anonymous — Fri, 22 Jul 2016 14:12:18 GMT

Hi Vasim,

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

I hope this can help you

Re: Nprinting doesn't insert all rows into Excel

chaudhariv — Fri, 22 Jul 2016 15:11:10 GMT

Hey Daniel, thanks I would try that but the weird thing is that when I changed straight table to Pivot, it worked perfect.

Thanks

Re: Nprinting doesn't insert all rows into Excel

Anonymous — Fri, 22 Jul 2016 15:47:25 GMT

I had the same problem, seems Nprintind doesnt recognize the total values in the straight table. wheen you check this option Nprinting knows that the first row are the total and shows the last row of the table.

If this works for you please mark as correct answer

Re: Nprinting doesn't insert all rows into Excel

Mon, 12 Dec 2016 06:04:05 GMT

I also figured the same solution.