Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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