topic Re: Need to avoid blank column in Excel. in QlikView

Need to avoid blank column in Excel.

jsingh71 — Mon, 15 Sep 2014 08:34:45 GMT

Hello Everyone,

I am facing one small issue. In our dashboard I pivoted one table and the name of pivoted dimension is blank. It is perfect in QV but when I click on send to excel button then this black column is also appering. My requirement is when user click on send to excel button then this blank column should automatically delete.

Re: Need to avoid blank column in Excel.

ashfaq_haseeb — Mon, 15 Sep 2014 08:40:06 GMT

Hi,

I don't think this is supported directly.

Unless you use some macro.

Regards

ASHFAQ

Re: Need to avoid blank column in Excel.

MK_QSL — Mon, 15 Sep 2014 09:13:38 GMT

Not supported directly in QlikView PivotTable

Re: Need to avoid blank column in Excel.

Tue, 16 Sep 2014 05:28:39 GMT

Hi,

You can try this macro.

Sub Export

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "D:\Export_test.xls"

Call ExcelCall

End Sub

Sub ExcelCall

dim oExcel, oWkBk

set oExcel = CreateObject( "Excel.Application" )

oExcel.Visible = true

set oWkBk = oExcel.WorkBooks.Open( "D:\Export_test.xls" )

oExcel.Cells(1,2).EntireColumn.Delete

oExcel.ActiveWorkbook.Save

'oExcel.ActiveWorkbook.Close

'oExcel.Application.Quit

set oExcel = nothing

End Sub

Regards,

Ravikumar

Re: Need to avoid blank column in Excel.

avinashelite — Tue, 16 Sep 2014 06:19:59 GMT

Hi Jsingh,

Its the default feature of QV, we cannot avoid that. Using Macro might solve your issue but it will poss performance issue.