Discussion board where members can get started with QlikView.
How to export data in excel file from a classical report along with chart title.
You can try using macros
Refer this link for more information:
How to export to Excel include Title Caption?
You could create a text object and make it look similar to the title, but you cannot export the title without macros.
'Set the path where the excel will be saved
filePath = "E:\TestBB.xls"
'Create the Excel spreadsheet
Set excelFile = CreateObject("Excel.Application")
excelFile.Visible = true
'Create the WorkBook
Set WorkBook = excelFile.WorkBooks.Add
'Create the Sheet
Set Sheet = WorkBook.WorkSheets(1)
'Get the chart we want to export
Set tableToExport = ActiveDocument.GetSheetObject("LB02")
Set chartProperties = tableToExport.GetProperties
'Get the caption
chartCaption = tableToExport.GetCaption.Name.v
'Set the first cell with the caption
Sheet.Range("A1") = chartCaption
'Paste the rest of the chart
'Save the file and quit excel
Set WorkBook = nothing
Set excelFile = nothing
Actually I want a generic solution for all classical reports used in my qlikview application not for a single or particular fixed classical report.
will try and l.u.k