Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Hemanth458
Contributor III
Contributor III

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

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.

 

Labels (1)
1 Solution

Accepted Solutions
Claudiu_Anghelescu
Specialist
Specialist

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

 

To help community find solutions, please don't forget to mark as correct.

View solution in original post

1 Reply
Claudiu_Anghelescu
Specialist
Specialist

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

 

To help community find solutions, please don't forget to mark as correct.

View solution in original post