topic Re: Saperate spreadsheet for different dimention in the same object in QlikView

Saperate spreadsheet for different dimention in the same object

Mon, 30 Jun 2014 14:31:50 GMT

Hi ALL

I would like to output data out of a qlikview object using a macro or anything that is easier to output the following data based on the field "Unique Student identification" in the object. that is for each "Unique Student identification" I would like to have it output to a separate spreadsheet with the name of the worksheet being the student name

Unique Student identification	Teacher	Parent	Student number
Worksheet 1	1	Mike 1	1937819
Worksheet 2	2	Mike 2	6712344
Worksheet 3	3	Mike 3	8021020
Worksheet 4	4	Mike 4	3323218
Worksheet 5	5	Mike 5	2811690
Worksheet 6	6	Mike 6	3477021
Worksheet 7	7	Mike 7	8545492
Worksheet 8	8	Mike 8	5779184

I would like the data output to 8 different worksheets with the names being for eg "Worksheet 4" for the forth student.

thank you

your response will be highly appreciated.

Regards

Smangaliso

Re: Saperate spreadsheet for different dimention in the same object

vgutkovsky — Mon, 30 Jun 2014 21:17:47 GMT

The general syntax is Sheets.Add. Take a look at this document: http://community.qlik.com/docs/DOC-3889

Regards,

Vlad

Re: Saperate spreadsheet for different dimention in the same object

Wed, 02 Jul 2014 06:45:08 GMT

Hi Vlad

I don't want it in different sheets on one spreadsheet I want the output to be in different spreadsheet.

Can I write a use a for statement where each of the Unique Student identification instead of doing this for each student?

aryExport(0,0) = "objSalesPerRegion"

aryExport(0,1) = "Sales per Region"

aryExport(0,2) = "A1"

aryExport(0,3) = "data"

aryExport(1,0) = "objTopCustomers"

aryExport(1,1) = "Top Customers"

aryExport(1,2) = "A1"

aryExport(1,3) = "data"

aryExport(2,0) = "objSalesPerYearAndRegion"

aryExport(2,1) = "Sales per Region a. Year"

aryExport(2,2) = "A1"

aryExport(2,3) = "data"

Regards

Smangaliso

Re: Saperate spreadsheet for different dimention in the same object

vgutkovsky — Wed, 02 Jul 2014 15:18:58 GMT

I'm a bit confused by your reply...are you by any chance mixing up the terms "spreadsheet" and workbook? A workbook is an Excel file. A spreadsheet is a sheet within a workbook.

Vlad