topic Missing last line in Send to Excel in QlikView

Missing last line in Send to Excel

Tue, 12 Oct 2010 16:33:45 GMT

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

Missing last line in Send to Excel

Mon, 08 Nov 2010 20:54:25 GMT

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?

Missing last line in Send to Excel

Wed, 06 Apr 2011 08:30:35 GMT

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.

Re: Missing last line in Send to Excel

jansen28 — Thu, 23 Aug 2012 15:17:57 GMT

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.