Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total on last row - hides rows

Hi,

I have this table with rows for an invoicereport. I'd like to sum at the last row but whenever I schedule it in Nprinting picking up the table it gives me correct Total but its like it comes on top of another row. See below the totals are correct but the following in 2 rows doesnt add up because of the total row showing above the 3rd row.

Without Totals it gives me that 3rd row as you can below...

19 Replies
cjohnson
Partner - Creator II
Partner - Creator II

Hi Niklas,


Does it show up this way when the total is in Qlikview or only when you schedule it in NPrinting?

Camile

Not applicable
Author

Good question...

If I enable the totals it runs fine in the app so to speak. Its jsut when Nprinting schedules it somehow deleted a row...

cjohnson
Partner - Creator II
Partner - Creator II

Is MarketId = PSE something that would get filtered out when you schedule it in NPrinting?

Not applicable
Author

Nope, no filtering

cjohnson
Partner - Creator II
Partner - Creator II

Can you try doing the total in Excel (through NPrinting) -- namely sum().

What is the outcome if you do that? How are the totals currently being generated? Have you tried putting subtotals on bottom in Qlikview -- what result does that generate?

stevelord
Specialist
Specialist

You might also check to see if there is a dimension limit in the qlikview set to show only.. first three MarketIds or something weird like that.  Dimension limit treats other and totals bars like one of the values, so I always have to pick top 6 if I want to show top 5 + Others bar or row.  Just a weird left-field thought to check for in this weird anomaly you have there.

(I was looking for a way to show only the totals row myself, and thought this subject might've been that.)

Not applicable
Author

No dimension limits is being used. Any who can think of a solution?

boorgura
Specialist
Specialist

Bumped into the same issue.

Straight table in Qlikview.

In Qlik, looks absolutely fine. Selected option for "totals at the bottom".

Without total, all the records show up in NPrinting output. But, when I enable totals(in the chart properties in the QVW), the NPrinting output has totals as the first row (though QV chart has them at the bottom) and the last row is deleted.

Similar to what Niklas has mentioned.

lmonincx
Creator II
Creator II

I have the same issue when migrating from nprinting 16.0 and QV 11.2 SR10  to nprinting 16.3 ( and 16.5 as well) and QV11.2 sr 11

although i am nog missing any lines in my straight tabel i can't get the totals at the bottom of the table, it was working fine in the old environment

I am wondering if the issue is in nprinting or in Qlikview

kind regards.

Linda Monincx