Missing last line in Send to Excel - Qlik Community

Report Inappropriate Content · ‎2010-10-12

We are diplaying Open Text answers in a simple TableBox that has the Send to Excel enabled. The plugin works well excepts it always omits the last row of the table box in the export.

I'm using Excel 2007 and Qlikview 9.00.7502.8 SR5 64 bit

Report Inappropriate Content · ‎2010-11-08

I am seeing similar behavior in a straight table.

Last row disappears, and the "TOTAL" line shows up twice (once on the first row , once on the last row)

QlikView 9.00.7646.9 SR6

I think this might be new behavior in the last couple of releases - I've never seen it previously.

Anyone have any ideas?

Report Inappropriate Content · ‎2011-04-06

I am seeing this happening as well on SR6 IE Plugin. Has anyone managed to get around this?

The only way i found so far was to do a fast change to a pivot table from a straight table and do the Send To Excel from there. You lose the totals, but at least all lines of data are exported.

jansen28 · ‎2012-08-23

We use Qlikview 9, SR6. Yes, even I came across - missing last line when 'send to excel' is enabled. In such case, I copy as Full table and paste in to excel. Not sure if this is one of the limitation in Qlikview 9 release.