Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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