Extracting Data from Table in Dashboard when task gets reloaded in Qlikview

[Hemanth458]

I need to extract the data from Qlik Dashboard into Flat file.

When ever the user selected some fields the extraction should be Auto-machine process.

My requirement is Very Urgent.

[Claudiu_Anghelescu · Accepted solution]

Use this Macro and  a trigger AfterReload which launch this Macro.

'--------------------------
' Export TableBox Routine
'-------------------------
sub ExportTableBox

output_dir="\\server001-ro\G$\QLIK_DATA\Source Documents\Sales\Sales_App\Output\"
Filename="output.xls"
set obj = ActiveDocument.GetSheetObject("CH198")
obj.Export (output_dir & Filename) , "|"

end sub