topic Re: Extract data from format and share automatically in exel file in QlikView

Extract data from format and share automatically in exel file

sarfaraz_sheikh — Wed, 28 Jan 2015 08:07:39 GMT

Dear All,

I have one format in one application.That format data should get share to business user in Exel File on dailly basis.

However, nowdays i am doing this manually as i do not want it to do manually .i want the data of particular format share with business user automatically.

What i can do so that the data automatically extracted from format and share with business user..Is there any way to achive the same.

Regards

Sarfaraz

Re: Extract data from format and share automatically in exel file

alexandros17 — Wed, 28 Jan 2015 08:23:59 GMT

Use this macro to export to Excel:

SUB EXPORT_Percentage
set sObject1 = ActiveDocument.GetSheetObject("CH_EXPORT")
set v = ActiveDocument.GetVariable("vOggi")
sObject1.ExportBiff "E:\qlik\Accounting\Daily Sales\Excel\" & v.GetContent.String & "_Daily_Summary_Export.xls"
end sub

and use this script into a batch file scheduled in Windows.

taskkill /f /im "Qv.exe"
"C:\Program Files\QlikView\Qv.exe" /r "E:\QlikSource\Sales\Daily_Export.qvw" >> E:\ScheduledTask\Daily_Export.log

The Macro must be triggered on the "OnPostReload" event of the documet

Re: Extract data from format and share automatically in exel file

sarfaraz_sheikh — Wed, 28 Jan 2015 10:23:50 GMT

Dear Alessandro,

I am very much new regarding the macro concept...It will be good for me if you post the file with example.

Sarfaraz