How to export data (conditional) into separate excel files thourgh script

[#1]

Hi ,

I am working on 9.0 PE & currently stuck at one point.

Our business requirement is such that , we need to provide output in separate excel files whcih inturn will be automatically uploaded to servers using different apllication .

For example :

Our sample output file in qilkview looks like below :

TransNo	Employee
28495530	Sam
44155946	Sam
22002281	Sam
44049134	Sam
44260772	Mark
21645156	Mark
23312382	Smith
24255610	Smith
28460876	Smith

Now i want this output to be exported in different excel files named with "Employee" .

So my output files will be as follow :

File 1 : FileName "Sam"

TransNo	Employee
28495530	Sam
44155946	Sam
22002281	Sam
44049134	Sam

File 2 : FileName "Mark"

TransNo	Employee
44260772	Mark
21645156	Mark

File 3 : FileName "Smith"

TransNo	Employee
23312382	Smith
24255610	Smith
28460876	Smith

Its a real challange for me , as we will be reciveing such work thrice a week with almost 100-125 Employee.

Pls pls help me out in this & i wil be greatful to all of you .

Regards,

Bhushan N

[biester]

Hi,

It could be a macro somewhat like this (you'll have to adopt of course):

rem get Possible Employees
set EmpListbox = ActiveDocument.GetSheetObject("LB01")
Emps=EmpListbox.GetPossibleValues
rem go through Employees
for empcounter = lbound(Emps) to ubound(Emps)
 rem clear previous selections
 ActiveDocument.ClearAll false
 rem Select Employee
 ActiveDocument.Fields("EMPLOYEES").Select Emps(Empcounter)
 rem Compose filename
 file="Employee" & Emps(Empcounter) & ".xls"
 set Chart2Export = ActiveDocument.GetSheetObject("CH01")
 Chart2Export.ExportBiff file
next

Perhaps that helps,

Rgds,
Joachim

[#3]

Hi biester ,

Thanks for your prompt suggestions.

But i didn't clear at end , how excel file generating with these distinct Employees. I am also try to explore meantime if you got time , requesting you to give some hints .

Thanks,

Bhushan N

[biester · Accepted solution]

Hi,

I don't quite understand what you want me to do. But to show how it works I made a full demo with a button to start the macro "Export".

Rgds,
Joachim

[#5]

Hi Joachim ,

During analysing on what you provided , I able to create own script. Your inuts acts as catalyst for me & i am very thankful for you for the same .

Regards,

Bhushan N

[#6]

Hi.

I suggest you check out this website: www.nprinting.com. They have a product which lets you export data from qlikview docs into excel. You can parse the data so that it is loaded onto different worksheets in Excel according to parameters you set. There's a video which shows how to create a excel report wirh data from QlikView.

You can also request a free trial.

Joseph

[camilo]

Hi,

I´m trying to generate the xls files with this example but they arent being created, and I dont see (in the macro) the path where those files are supose to be created.

Can someone help me with this example please.

Thanks a lot,

Camilo

[hectorgarcia]

Hola Camilo,

I just modified this line and worked

file="c:\"&"Employee" & Emps(Empcounter) & ".xls"

I hope it will help you

Hector