topic Exporting to Excel - Without Fill Gaps in QlikView

Exporting to Excel - Without Fill Gaps

Fri, 10 May 2013 09:28:10 GMT

I'm trying to export a table from Qlikview into Excel by clicking the 'XL' button. Works fine, but once in excel it 'fills gaps' for every empty cell in the table to reflect the cell above. Can anyone advise how I stop it from doing this?

Thanks!

Dipen

Re: Exporting to Excel - Without Fill Gaps

Gysbert_Wassenaar — Fri, 10 May 2013 09:42:10 GMT

The only way to do that without resorting to macros is to right click the pivot table, choose Copy to Clipboard, select Full Table and then open Excel and choose Paste. The Send to Excel option and the XL button send the complete records that are used to display the pivot table to Excel without any formatting.

Re: Exporting to Excel - Without Fill Gaps

calvindk — Fri, 10 May 2013 09:45:08 GMT

An alternative to that if you have users that do this often, is to create your own macro for pivot exporting.

There might be someone who already made one, but that should be searchable.

This will require VBA coding, and that you allow your document to 'use potentially unsafe macros'

Re: Exporting to Excel - Without Fill Gaps

Fri, 10 May 2013 09:58:38 GMT

Also try using the right click on the chart -> Export -> give the name with the extension .xls

this might work............. Please try it.

Re: Exporting to Excel - Without Fill Gaps

Fri, 10 May 2013 10:34:54 GMT

Thanks all most helpful