Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

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
Contributor II

Re: Total on last row - hides rows

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

Re: Total on last row - hides rows

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
Contributor II

Re: Total on last row - hides rows

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

Not applicable

Re: Total on last row - hides rows

Nope, no filtering

Highlighted
cjohnson
Contributor II

Re: Total on last row - hides rows

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
Valued Contributor

Re: Total on last row - hides rows

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

Re: Total on last row - hides rows

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

boorgura
Valued Contributor

Re: Total on last row - hides rows

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
Contributor II

Re: Total on last row - hides rows

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

Community Browser