topic Re: Export the specific chart data into excel after reloading data in QlikView

Export the specific chart data into excel after reloading data

deepakqlikview_123 — Mon, 30 Mar 2015 06:20:22 GMT

My requirement is

Export the specific chart data into excel after reloading data, is this possible by using macro.

Thanks

Re: Export the specific chart data into excel after reloading data

Mon, 30 Mar 2015 06:27:43 GMT

hi,

yes use trigger to run macro after reload the application.

Regards

Vimlesh

Re: Export the specific chart data into excel after reloading data

Anonymous — Mon, 30 Mar 2015 06:28:14 GMT

Yes you can.

See this doc

Useful Qlikview Macros

Thanks

BKC

Re: Export the specific chart data into excel after reloading data

deepakqlikview_123 — Mon, 30 Mar 2015 07:05:01 GMT

I am using macro as per below

FUNCTION ExcelExport(CH78) set obj = ActiveDocument.GetSheetObject( CH78 ) w = obj.GetColumnCount if obj.GetRowCount>1001 then h=1000 else h=obj.GetRowCount end if Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Add objExcel.Worksheets(1).select() objExcel.Visible = True set CellMatrix = obj.GetCells2(0,0,w,h) column = 1 for cc=0 to w-1 objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text objExcel.Cells(1,column).EntireRow.Font.Bold = True column = column +1 next c = 1 r =2 for RowIter=1 to h-1 for ColIter=0 to w-1 objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text c = c +1 next r = r+1 c = 1 next END FUNCTION SUB CallExample ExcelExport( "CH78" ) END SUB

but it is giving me error as macro parse failed functionality was lost.

Thanks

Re: Export the specific chart data into excel after reloading data

Srinivas — Thu, 02 Jul 2015 10:11:24 GMT

Hi Vimlesh,

I want to export specific chart(straight table) to excel after reloading ,This reloading also happen every day morning times so for every day reloading I have created batch file, So automatically application reloading and excel exporting to specific folder I need.

So how to export excel after reloading.this is my question could you please help on this.

Advance Thanks,

Munna

Re: Export the specific chart data into excel after reloading data

Thu, 02 Jul 2015 13:58:52 GMT

hi,

Create a macro to send report.

and trigger the macro afterpost reload.

search code in google.i don't have right now.