Need to avoid blank column in Excel.

[jsingh71]

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.

[ashfaq_haseeb]

Hi,

I don't think this is supported directly.

Unless you use some macro.

Regards

ASHFAQ

[MK_QSL]

Not supported directly in QlikView PivotTable

[#4 · Accepted solution]

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

[avinashelite]

Hi Jsingh,

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