Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Saperate spreadsheet for different dimention in the same object


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
TeacherParentStudent number
Worksheet 11Mike 11937819
Worksheet 22Mike 26712344
Worksheet 33Mike 38021020
Worksheet 44Mike 43323218
Worksheet 55Mike 52811690
Worksheet 66Mike 63477021
Worksheet 77Mike 78545492
Worksheet 88Mike 85779184

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

3 Replies
vgutkovsky
Honored Contributor II

Re: Saperate spreadsheet for different dimention in the same object

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

Regards,

Vlad

Not applicable

Re: Saperate spreadsheet for different dimention in the same object

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

vgutkovsky
Honored Contributor II

Re: Saperate spreadsheet for different dimention in the same object

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