Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi Niklas,
Does it show up this way when the total is in Qlikview or only when you schedule it in NPrinting?
Camile
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...
Is MarketId = PSE something that would get filtered out when you schedule it in NPrinting?
Nope, no filtering
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?
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.)
No dimension limits is being used. Any who can think of a solution?
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.
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