Discussion board where members can get started with QlikView.
I have a new requirement.I need qlikview table data export to excel automatically by daily basis.
can you please give some guidance.
By using micro we can export by clicking only but my client need daily basis without open the report.
Reload the attached file.
View solution in original post
1.Create a qvw with a macro that can export data to excel.
2.Add Trigger to it in Document properties to activate sheet
3.Add Trigger to in sheet properties for calling Macro on sheet activation.
4.Create Batch file to run QVW
5.Schdule Batch file in windows schduler.
I have a couple of questions if you don't mind. Does the 4 at the end of the obj1.Export line represent the number of columns to be exported? And my second question is there a way to export the data in .xlsx format? Thanks in advance.