Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The general syntax is Sheets.Add. Take a look at this document: http://community.qlik.com/docs/DOC-3889
Regards,
Vlad
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
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