Exporting data, charts and tables (askiaanalyse)

Exporting data, charts and tables (AskiaAnalyse)

AskiaAnalyse allows you to export data:

to a new QES file;
to an external program, such as Word, MS Excel, PowerPoint.

Exporting data to a QES file

You can export part or all of a questionnaire, as either a number of individual respondents (sub-population), or as questions. You can also use this feature to export an askiasurf QEW project (with many waves) as a single, stand-alone QES file.

To export data, open the file menu and select export a sub-population... or export a set of questions... as appropriate. For details, follow the links below:

Exporting a sub-population
Exporting a set of questions

Exporting a sub-population

The export a sub-population... feature allows you to export the questionnaire, and include only the interviews corresponding to the specified sub-population.

Select an existing sub-population, or create one.
Enter a name for your new QES.

To export the sub-population in inverted data format, select exported as inverted database. This allows fast exporting of data from a QES, AskiaField surveys, and for AskiaSurf files. When exporting to an inverted file, you can include calculated variables in the export by selecting them in the list. This is particularly useful if you are exporting to another analysis package, and you want to include a calculated question based on weighting. Note that you can include questions that have been hidden (with the not visible in analyse setting in AskiaDesign), by changing the global AskiaAnalyse setting show "not in analyse" questions anyway.

Note: In early versions of AskiaAnalyse 5.3.3, if the option export to inverted database was used, incorrect level ID files were created. This meant that when interviews were merged from the inverted file, developed questions were not read in AskiaAnalyse 5.3.4. If you cannot re-export the data with AskiaAnalyse version 5.3.4 or later, which is the preferred remedy, you can use the AskiaTools feature fix inverted files to repair the problem with the inverted database.

Note: you can exclude questions from the export by using the command line switch /exclude, for example /"exclude:q4;q5". If any of the questions are in loops, all parent loops will be automatically added. Note that you cannot use the switches /exclude and /questions together.

Exporting a set of questions

The export a set of questions... function allows you to create a new .qes containing only the specified variables.

Select the level for export. This allows you to export questions from a specific data level. An alternative method is by using the stacked export feature of AskiaTools.
In the directory tree, select the questions you want to export and drag them to the window.

Note: when you use export a set of questions, all questions in a loop are flattened into one level. To allow you to export multi-level data, it is possible to combine exporting a sub-population with exporting a set of questions. This is achieved by using the command line. Use the switch /"questions:q1;q2;q3", where q1, q2 and q3 are the questions you want to export. If any of the questions are in loops, all parent loops will be automatically added. Note that you cannot use the switches /exclude and /questions together.

Exporting from charts and tables or portfolios

You can export directly from your charts and tables or from portfolios:

to an analysis file, then from that file to Word, MS Excel, PowerPoint or in ASCII;
directly to Word, Excel, PowerPoint, or an ASCII file.
by copying entire tables, or parts of them, to the clipboard, and pasting them into Excel.

To export charts and tables, in the file menu, click export, and select the type of export you require. Alternatively for exports to Word, Excel or PowerPoint, you can use the equivalent shortcuts in the standard toolbar (when you are viewing the table definition results or a portfolio).

Note: you can customise the content and look of your exports to Word, Excel, PowerPoint and ASCII in the program options.

Word: Specify a location and name for an RTF (Rich text Format) document and it will open automatically in Word. You can customise the export by setting certain program options: see Word export options.
Excel: The file will open automatically in Excel. You should then save the spreadsheet in a location of your choice. You can export in xlsx format, for Excel 2007 or later, or xls format, for earlier versions. Note: There is a limitation of 65535 rows per sheet. You can customise the export by setting certain program options: see Excel export options.
PowerPoint: The file will open automatically in PowerPoint. You should then save the file in a location of your choice. The appearance of the PowerPoint file can be determined by the content of an external design template (*.pot). This is optional, and can be specified in the options dialog). Note: PowerPoint tables are limited to 25 rows. You can customise the export by setting certain program options: see PowerPoint export options.
ASCII: Specify the location and name for the text file, then open it from any text editor. You can customise the export by setting certain program options: see ASCII export options.
TabsML: This command is available only when you are viewing a portfolio, and allows you to export the portfolio to TabsML ( .xml) format. Specify a location and name for the file. The export can be in ANSI or Unicode format, depending on the Export in Unicode option in the options dialog. Set the option to no for ANSI exports, and yes for Unicode exports.

Create your own Knowledge Base