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

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

Fri, 25 Sep 2009 13:52:48 GMT

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

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

biester — Fri, 25 Sep 2009 14:10:50 GMT

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

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

Fri, 25 Sep 2009 17:23:12 GMT

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

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

biester — Fri, 25 Sep 2009 21:02:26 GMT

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

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

Wed, 30 Sep 2009 13:16:33 GMT

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

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

Wed, 25 Nov 2009 22:55:08 GMT

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

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

camilo — Thu, 11 Aug 2011 20:06:59 GMT

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

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

hectorgarcia — Mon, 17 Oct 2011 12:57:04 GMT

Hola Camilo,

I just modified this line and worked

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

I hope it will help you

Hector