Release Notes

From Q
Jump to navigation Jump to search

The changes in each new version of Q are listed below.

  • Bug fixes.

  • Bug fixes.

  • Date period filter terms now include "within last" to allow selecting a time period to filter by in addition to "within last period"
  • The Javascript formula option has been returned to the weighting dialog.
  • Bug fixes.

  • Bug fixes.

Online Feature Release

  • An update to the design-based Akaike Information Criterion (dAIC) for weighted Regression - Linear Regression models. The updated criterion accounts for sampling weights as before but computes the penalty using all regression parameters including the variance parameter. This update is live from Nov 1st and will align with the to be released version 4.3 of the R survey package on CRAN,

Online Feature Release

  • Removed Automate > Browse Online Library > Data > Google trends from the menu.

  • Bug fix.

  • Bug fixes.

Online Feature Release


R version 4.3.1 has been released for Q users! Upgrades like this are important to keep all of the R-based features up to date, and in order for us to stay up to date with the latest security patches. As with all system upgrades, there can be small numerical differences in outputs due to changes in randomization and numerical precision. Q's advanced analysis tools have been thoroughly tested with this upgrade, and no differences of commercial relevance have been identified. If you notice a change that is concerning, please contact Features in which you may notice small differences include:

  • Dimension Reduction
  • Regression
  • Choice Modeling
  • Max Diff

The new version of R is more conservative in some small ways to help R users to write better code. Changes to the way you write code are documented in this article. If you write custom R code in Q and have not yet had a chance to review this, then please do so.

Finally, the Brand Health Table may encounter an error in some cases. A tool has been added to Q to address this problem. Please see this article if you run into any problems with the Brand Health Table.

  • Bug fixes.

  • Added translate functionality to text coding dialog. Allows users to translate text responses to their chosen language via Google's API
  • Revamped custom footers dialog
  • Speed improvements in tables using banners
  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Improved table caption editing dialog
  • Security improvements
  • Bug fixes.

Online Feature Release

July 2022
  • Expanded feature for Automate > Browse Online Library > Table Computations > Difference between pair of columns and Automate > Browse Online Library > Table Computations > Difference between pair of rows. Indexed positions for Column or Rows can be specified. E.g. the Last Row - 2nd Last Row. Useful when a data update will add extra rows or columns to the table.

Online Feature Release

June 2022
  • Expanded feature for automatically combining categorical data based off patterns (using CHAID) available in Automate > Browse Online Library > Create New Variables > Automatically Combine Categories > By Pattern (CHAID):
    • Adjacent Categories: Now possible to specify if some categories should be treated as unordered. E.g. "Don't know" category is allowed to merge with any other category while the other categories are only allowed to combine with adjacent categories.
    • Adjacent Categories Unless Missing Value Code: Same behaviour as the Adjacent Categories feature except any categories which are coded with a value of NaN in the Value Atrributes with be allowed to combine with any other category.

  • Bug fixes.

  • The Advanced Statistical Testing Assumptions Dialog has been updated and new options added.
  • Additional security options for your Q Customer Page
  • Bug fixes.

Online Feature Release

April 2022
  • New tools for automatically combining categorical data based off patterns (using CHAID) are now available in Automate > Browse Online Library > Create New Variables > Automatically Combine Categories > By Pattern (CHAID):

Online Feature Release

February 2022

  • Added column comparison support for chart exporting to PowerPoint.
  • More logical anchoring of items when sorting (e.g. SUM, NET, “Other”, “None”)
  • The weight dialog has been redesigned to make it easier to use and more powerful. Have a look How to Configure a Weight from Variable(s) in Q. The weights are now computed using R, and may occasionally result in minor differences in weight values when using multiple Adjustment Variable Sets.
  • We have introduced new visualizations for use in Q.
  • Bug fixes.

Online Feature Release

September 2021
  • Automate > Browse Online Library > Tables > Combine Tables now allows you to override row and column names in the combined table.

Online Feature Release

August 2021
  • Added the Propensity Weight extension button to return the Propensity Weights of a regression or machine learning output that is a binary classification model.

  • Bug fixes.

  • Bug fixes.

Online Feature Release

July 2021
  • Machine Learning and Regression analyses, such as Regression - Linear Regression and Machine Learning - Random Forest, can now return very large outputs when working with big data sets. To enable, select the analysis and check Increase allowed output size in the Object Inspector and increase the limit in the dropdown that appears.

Online Feature Release

June 2021

  • Fixed a problem where exporting to PowerPoint to update a file created in an earlier version of Q did not update footers.
  • Minor bug fixes.


Online Feature Release

March 2021

Online Feature Release

February 2021
  • Percentage data in R tables is now represented in the same way as Q tables (that is, they are no longer stored as decimals).
  • Column Chart visualizations has a new group of controls to add annotations that are separate from data labels and can be more flexibly positioned.
  • Data label annotations in Column Chart, Bar Chart and Line Chart visualizations has new annotation types Caret - up and Caret - down.
  • Features in the menus have been renamed. See Menu Changes (February 2021).
  • Bug fixes for Radar Chart, including improved label placements. Axis and gridlines can now be shown in radar charts with small multiples.
  • Annotations can now be added to Radar Chart. These can be attached to data labels or to the category labels.

Online Feature Release

January 2021
  • Lots of Crosstabs (Create > Tables > Crosstabs) now allows users to choose which statistics should be shown on the created crosstabs.
  • Improved controls for selecting "must include" and "mutually exclusive" alternatives in TURF - TURF Analysis. The constraints are now specified via comboboxes containing permitted options instead of dropboxes containing all variables in the data sets. This also permits "must include" and "mutually exclusive" alternatives to be specified for Pick Any - Compact questions.

  • You can now link Q to existing PowerPoint documents in PowerPoint so that it automatically updates”,
  • It is now possible for the user to change a Text Variable to a Categorical Variable in Variables and Questions > Variable Type
  • Speed improvements
  • Bug fixes

Online Feature Release

December 2020

Online Feature Release

November 2020

Online Feature Release

October 2020

Online Feature Release

September 2020
  • The varimax rotation algorithm for Text Analysis - Advanced - Principal Components Analysis (Text) has been modified to perform better with larger data sets. This may result in slight differences in output. Also the return object has been trimmed to have a small memory footprint.
  • An update has been made to Text Analysis - Advanced - Term Document Matrix so that it accounts for ngrams in the Text Analysis Setup item. The output is now in a sparse matrix format of class dgCMatrix, which is more broadly used than the previous format.
  • The Suggest feature which provides suggestions for categories in the text coding interface (accessed by right-clicking text variables in the Variables and Questions Tab and selecting one of the options under Insert Variables > Code Text) now runs faster for larger data sets (over 1000 cases).
  • The algorithm for the Sort by > Similarity to [category] feature in the text coding interface (accessed by right-clicking text variables in the Variables and Questions Tab and selecting one of the options under Insert Variables > Code Text) has been updated, which may result in differences in the sorting of cases.
  • The underlying algorithm for Text Analysis - Automatic Categorization - Unstructured Text, Text Analysis - Advanced - Principal Components Analysis (Text) and text coding has been modified for better performance. This may result in differences in output such as generated categories, principal components and suggested categorizations.
  • The algorithm for categorizing with an existing categorization in Text Analysis - Automatic Categorization - Unstructured Text has been updated. This may result in differences in categorization.
  • Text Analysis - Advanced - Setup Text Analysis now shows a page of raw text in the output. The controls Page of raw text to show and Rows of raw text per page have been added, allowing the page number and page size to be specified. Previously all the raw text was shown, potentially resulting in an error or unresponsive output for large datasets.

Online Feature Release

August 2020

Online Feature Release

July 2020
  • Visualization - Scatterplot has new option to use category labels instead of values so that row or span labels can be used in the X coordinates, Y coordinates, Sizes or Colors variable.

  • A new PowerPoint exporting option has been added at File > Export > To office > Fast PowerPoint Update. Select an existing PowerPoint document. Q will then update the charts and tables to match the data in Q.
  • Speed improvements
  • Bug fixes

Online Feature Release

June 2020

  • Bug fixes

  • Bug fixes

  • Bug fixes

  • Bug fixes

Online Feature Release

May 2020

  • Bug fixes

  • Bug fixes

  • This release includes major improvements and a new interface for Text Analysis, especially options under Create > Text Analysis > Advanced
  • Users can now customize the labels used for quarters under Edit > Project Options > Customize > Output Text
  • Speed improvements
  • Bug fixes

Online Feature Release

April 2020
  • Visualization - Line Chart now has the option to add data labels and markers to the end points of each series only.
  • Regression - Driver Analysis added to the menu to facilitate quick driver analysis options and data stacking.
  • Text Analysis - Advanced - Principal Components Analysis (Text) added allowing the option to analyze text data by conducting a PCA via a numeric text encoding. The correlation of the PCA scores with a type of document term matrix is used to help interpretation and a varimax type rotation is conducted by default to help facilitate the interpretation (the rotation can be not conducted if desired).
  • The order of Row and column manipulations in Visualizations has been modified to make it easier to apply multiple manipulations. The operations are now performed in the following order: Hide empty rows/columns, Hide rows/columns with small sample sizes, Rows/Columns to show, Sort rows/columns, Order rows/columns by similarity, Rows/Columns to ignore, Number of rows/columns from top/left to show, Number of rows/columns from from bottom/right to show.
  • Segments - Segment Comparison Table now has more options for shading significant values. These output options are now available in Segments - K-Means Cluster Analysis when the output type is Segment profiling table.
  • Create New Variables - Translate added to the menu allowing translation of text questions to another language.
  • New transformation QScripts are available in Create New Variables > Scale Within Case and Create New Variables > Scale Within Variable. The QScripts formerly named Rank Within Variable, Rank Within Case, and Standardize Data by Case have been moved to these submenus. The new QScripts are 1) Standardize Within Case, which transforms data to have mean 0 and standard deviation 1, 2) Center Within Variable, which transforms data to have mean 0, and 3) Unit Interval Within Case, which transforms data to have minimum 0 and maximum 1.

Online Feature Release

March 2020

Online Feature Release

February 2020
  • Regression - Linear Regression and the other six regression types now have an automated outlier removal option. The new input control is called Automated Outlier Removal Percentage and accepts a numeric value between 0 and 50 (including 0 but not 50). If a non-zero value is selected for this option then the regression model is fitted twice. The first regression model uses the entire dataset (after filters have been applied) and identifies the observations that generate the largest residuals. The user specified percent of data values that have the largest residuals are removed from the data. The regression model is refitted on this reduced dataset and output returned. If a zero-value is selected for this input control then no outlier removal is performed and a standard regression output for the entire (filtered) dataset is applied.
  • More formatting options for secondary data series has been added to Visualization - Column Chart
  • Added support for text data in languages other than English in Text Analysis - Automatic Categorization - Unstructured Text through the new Source language control.
  • Visualization - Scatterplot has been updated so that Row/column manipulations are applied to the input table in the same way as other visualizations when Input data contains y-values in multiple columns is selected.

Online Feature Release

January 2020

Online Feature Release

December 2019
  • Shapley Regression available for Regression - Linear Regression.
  • Tick labels in Scatterplots with categorical axis is now ordered according to the order they appear in input table (instead of alphabetically).
  • Regression outputs with imputated values may have small changes due to an upgrade to mice version 3.7.0.

  • Bug fix.

Online Feature Release

November 2019

  • The standard error shown on tables of correlations was computed using (1 - R2)/sqrt(n - 1). This is not correct. It now is computed using sqrt((1-R2)/(n-2)). The statistical tests were using the correct formula, so no change has occurred in terms of which results are flagged as significant.
  • On summaries of numeric variables, the standard deviations and associated statistics (standard errors and statistical tests) had an error in them whereby they failed to take missing values into account. If a study has extremely high rates of missing data these may have caused non-trivial differences. This only affected summary tables; not any crosstabs.
  • Errors in Independent Complex Samples t-Test / z-Test:
    1. Column Comparisons report statistically significant differences between values which are identically 100.
    2. Where the user has chosen to apply a z-Test to test means on this table (Edit > Project Options > Customize > Statistical Assumptions > Statistical Tests for categorical and numeric data > Means > z-Test), but when using the 'alpha' button to test significance the output is providing a link to the t-Test version of the complex samples test for means.
  • Bug fixes.

  • Incremental improvements to data and R code handling to improve speed.
  • Bug fixes.

Online Feature Release

October 2019

Online Feature Release

September 2019

  • Bug fix

Online Feature Release

August 2019

  • Fixed bug in planned significance test results where all cells in the table including the NET are selected were not being shown for crosstabs of Number (blue question) and Pick One (brown question) in the case where there is missing data in the Pick One question. This also fixes an issue with Smart Tables where these crosstabs may have been incorrectly labeled as insignificant.
  • Minor bug fixes

Online Feature Release

July 2019

  • Bug fixes.

  • Addresses speed issues which occur when using double bit character sets (such as Chinese).
  • Other bug fixes.

Online Feature Release

June 2019

For details of new online features released up to June 2019, see here.

  • Corrects errors in importing data from MDD files.
  • Prevents crashes caused by adding filters from different data files.
  • Corrects an issue updating with new cases from an Excel file when the original file contained blank rows.
  • Corrects an error which prevented updating from a datsa files with more variables than the original.
  • Corrects rendering of headings in complex banners.
  • Prevents an error when using text analysis setup on data which includes Unicode line separators.
  • Prevents data being shifted when exporting data with double byte (including Chinese) characters to .csv files.
  • Allows the merging of cases from larger data files without triggering out-of-memory errors.
  • Retains the value atributes of an R variable when undo is used.
  • Minor bug fixes.

  • Bug fixes.



  • Support added for displaying multi column data frames for R Variables.

Bug fixes

  • Fixed problems importing from Qualtrics if the default save directory does not exist.
  • Corrected the size used for exported wordclouds.
  • Minor bug fixes.

  • Fixed an issue where the "Independent" option for column comparisons overlaps was not being observed.
  • Fixed slowdown in Q when project contained hundreds of tables.
  • Other bug fixes.

  • When specifying a range of dates in the Date/Time settings for a Date variable, the minimum and maximum will now default to the start and end of the days in the range.
  • If an Excel/CSV data set looks to contain tabular data (e.g. aggregated statistics) rather than raw data, the user will be given the option to instead add it as a table.
  • If a filter or weight is applied to an R calculation that uses variables from different data sets, then there must be a relationship defined between those data sets. The filter/weight will be resized to suit the joined data. Note that we do not yet join the other input variables, but may in future.
  • Fixed an issue where variables using Recode Rules would include original code values and labels when "Copy and Paste Variable(s) > Linked" was used.
  • QScript can now export to Excel files.
  • PowerPoint exports of R Outputs include transparency, so they will look good in templates.
  • Bug Fixes

  • Bug fixes

  • Bug fixes

  • Bug fixes

  • Membership probabilities corrected in weighted Mixed-Mode Trees
  • Changed data format for Excel charts to avoid double line breaks in axis labels.
  • Added validation of variable names and questions in R variables created via QScripts.
  • Fix an issue in legacy PCA observed when the number of observations is less than the number of components.
  • Improve .QCodes file import
  • Bug fixes

  • Improve speed of cross-tab generation.
  • Enabled table footer setting 'Include when columns compared'.
  • In legacy regression, if predictors have missing values then predictions will also be missing.
  • The maximum size of R output that can be exported to PowerPoint, or PDF is now limited to 6000 by 6000 pixels, to prevent exports being blank.
  • Exported to PowerPoint Excel Charts are now updated when statistics shown change.
  • Bug fixes for .MDD data file reading.
  • Other bug fixes.

  • Improve Qualtrics integration.
  • Fixed an issue that prevented editing R data set code.
  • It is possible to read a table value of R output in QScript using .table property.
  • Improve hypothesis testing of ranking questions.
  • Add/Edit Table widget now support up to 1000 rows of data.
  • Other bug fixes.

  • Q can now load survey data directly from Qualtrics without requiring user to download *.sav data files first.
  • The way that the JavaScript language evaluates 'if' statements without an 'else' has changed. This may affect some hand-coded JavaScript variables in old projects. Q should detect affected variables and mark them as in error, forcing you to fix them. See Changes to JavaScript if.
  • Bug fixes.

Known Qualtrics import limitations

  • Q does not currently support importing surveys with more than 1 million responses.
  • Qualtrics Side-by-Side questions may have missing data for some multiple-response questions within them. In particular, responses in which the user has not selected a particular checkbox may be considered missing for the corresponding variable. Qualtrics has acknowledged this issue, and intends to fix it in future.

  • Improved handling of categorical variables in MDD data sets.
  • Bug fixes.
  • Known issue. In rare cases the 'Undo' (Ctrl + Z) operation may not work after new filter is created from table cells.

  • R calculations done in R Outputs are now allowed to continue for up to 1 day.
  • Due to changes in the software on which Q is built, the order of rows may change in the following outputs:
    1. Matched data sets (which will affect results when using Data Fusion).
    2. Auto-coded categorical variables (which will result in a different ordering of some categories when Text variables have their Variable Type changed to Categorical).
    3. The list of subsets in the Homogeneous Subsets section in some significance tests.
  • Q now requires .Net 4.5 to be installed.
  • Bug fixes

  • Bug fixes

  • Bug fixes

  • Fixed bug where rounding errors can result in the treatment of the median, percentiles and effective sample size to be inconsistent. Based on our sensitivity analysis we have confirmed that this only leads to changes in results in situations where the change is immaterial. In the case of the median, this issue arose on the rare occasion when the median occurred at the middle of two different values. Due to rounding errors, the median was randomly reported as either the higher or lower value, when it should have been the midpoint between the two values. In most cases when this does occur, the two values will be close and the resulting error will be small.
  • Other bug fixes

  • Improve import of MDD data files.

  • Improve import of MDD data files.
  • Other bug fixes

  • Date variables can display time in charts and tables. Date variables can be aggregated using hours, minutes, seconds or milliseconds.
  • Previously when a variable from a Pick Any question only had Missing Data and 1 as values, 1 would not be counted, resulting in 0% shown in the table. 1 is now counted and shown as 100% in the table.
  • Q requires .Net 4.5.2 to be fully operational.
  • It is now possible to hide tables, charts, R outputs and complete folders from export using Hide from the context menu.
  • R Outputs returning scalar values and strings are now exported as text to PowerPoint and Word.
  • Fixed bug where multiple comparisons correction in Table Options was ignored in Driver Analysis.
  • Fixed question naming issues when importing MDD data files.
  • Improved looped question detection when importing MDD data files.
  • Fixed bug where an incorrect log-likelihood was reported when weights were applied in Segments > Latent Class Analysis.
  • Other bug fixes.


  • Data tables can now be manually entered or pasted in Q via Create > Tables > Enter Data and Paste Data, as well as in Standard R items that accept tabular inputs.
  • Other improvements and bug fixes.

  • Machine Learning - Random Forest
  • Analysis of Variance - One-Way ANOVA
  • Analysis of Variance - One-Way MANOVA
  • Fixed bug with Spearman’s Correlation where Spearman ranks were being calculated without omitting the cases with missing values in any of the two input variables. The impact of this bug should be minimal and proportional to the amount of missing values in the data set. We have observed that the bug typically resulted in a difference in the reported Spearman correlation at the 4th decimal place compared to the correct value. As a result, is unlikely that this bug would have affected Spearman correlation significance test results and any inferences made from them.
  • Improved Qualtrics and Survey Gizmo data file detection
  • Fixed a bug where by the word "mean" was appearing in the place of "proportion" in some test outputs.
  • Other bug fixes and improvements

  • Bug fixes



  • Bug fixes

  • Bug fixes

  • Bug fixes


  • Bug fixes

  • Bug fixes

  • Bug fixes

  • Bug fixes

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Export to Excel (fast) now works without Office installed.
  • New Table Context Menu items allow you to modify questions without leaving the table, including renaming the Question and changing its Question Type.

  • Banners can be modified directly on tables by dragging and dropping column spans.
  • Individual banner points can be added directly on tables using new concise Logic formulas.
  • New Ranking plot visualizes changes in ranks as a series of colored ribbons.

  • Bug fixes.

  • Significance arrows and column comparison letters are now included in Excel spreadsheets and PowerPoint chart labels.
  • Bug fixes.

  • Bug fixes.

  • Bug fixes.


  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Q is faster when working with large data files (100,000+ cases).
  • New Find and Replace feature allows you to search everything in your project: tables, variables, value attributes, raw data and more.
  • Improved importing of CSV and Excel data files.

  • Bug fixes.


  • The tables created by Automate > Browse Online Library > Driver (Importance) Analysis can now be crosstabbed against Pick One, Pick Any and Date questions.
  • TURF is now available from Automate > Browse Online Library, allowing you to select products and maximum portfolio size.

  • Bug fixes.

  • Bug fixes.

  • Rules let you automatically highlight important cells and reformat tables.
  • Significance of table cells is now calculated by Q prior to Rules. This allows Rules to format tables based on Corrected p, and to modify arrows and font colors.
  • Driver (Importance) Analysis is available from Automate > Browse Online Library.
  • Tables of Pick Any - Compact questions now automatically remove respondents who were not asked the question.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Project Templates let you set default statistical assumptions, table styles, colors, etc. for new projects.
  • Bug fixes.

  • The QScript Online Library provides pre-written QScripts to perform common tasks. It is available in the Tools menu, QScripts, Online Library.
  • Use Excel spreadsheets as raw data.
  • Now much easier to control whether/how significance is shown for any table/plot. Look for the new "Show significance" toolbar.
  • Plots can now show column comparisons.
  • Plots can show significance arrows without also needing to show labels. Most plots now show significance by default.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Tables with no data will no longer stop Microsoft Office exports mid-stream.
  • During text coding, codes may now have the same name so long as they do not have the same parent code.
  • Fixed inconsistent spacing between letters on plots exported as pictures to PowerPoint or Word.
  • Axis labels on plots can be turned off.
  • Bug fixes.

  • Text questions can now be crosstabbed against Pick One, Pick Any, Pick Any - Compact or Date questions.
  • Excel table exports can now be formatted using Excel's table styles, within Q.
  • Bug fixes.

  • Bug fixes.

  • Q now works with R3.0.1.
  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • You can specify the gaps between tables when exporting all tables to a single Excel worksheet.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Help | Interpret This Table prepares a summary of some of the salient aspects of a table.
  • Basic Tables has a new checkbox that allows you to add all crosstabs into a single group (instead of adding one group for each Key question's crosstabs).

  • Export to native PowerPoint tables. These look much better than the old tables, and will work with PowerPoint table styles.

  • Bug fixes.

  • Bug fixes.

  • Bug fixes.

  • Time series charts allow you to select the statistic to be plotted.
  • Significance tests on Number questions now test against an expected value of 0.0 (previously no result was shown).
  • Choice of significance tests for grid questions (e.g., Nonparametric, z-tests, Quantum and Survey reporter).

  • The multiple comparison correction for Column Comparisons can now be applied to the whole table, or, within each row and span. (Previously it was only applied within each row and span.)
  • Symbols used in Column Comparisons (e.g., upper case for significance levels than 0.001 and lower case for between 0.001 and 0.05 are now computed using the Corrected p. Previously they were computed using p. Note that this does not change which column comparisons are marked as significant, it only changes the letters used. Also note that this change only affects users on the beta, as the different column letters are not available in older versions of Q.
  • Improved warnings when Experiment questions have been setup incorrectly.
  • Modified list of Multivariate Tests (no change in the tests, but modified names of the tests).
  • The Independent Complex Samples t-Test - Comparing Two Means is now the default test employed with weighted data (previously a version assuming equal variance was applied in situations with small sample sizes).
  • The Independent Samples t-Test - Comparing Two Coefficients for an Experiment and Ranking questions now uses the effective sample size when computing the degrees of freedom (previously it took into account the effective number of observations).


  • Fixed problem with three-dimensional crosstabs with Date questions in the brown dropdown.
  • Fixed problem with Column Comparisons in three-dimensional crosstabs.


Please note: a number of the new features described here were available in some earlier 4.3 releases.

  • Pie charts.
  • JavaScript variables now have the ability to reference variables in other data files.

  • When (for example) you restrict a weekly Date question to end on a Wednesday then calculated weeks will go from Thursday to Wednesday. Similarly for months and years. Previously Q moved periods to match natural boundaries (Sunday, end of month, etc) in this case.

  • Q can read SPSS Data Collection Data Files (.mdd + .ddf).
  • New and improved JavaScript variable editor.
  • Edit | Table JavaScript - allows you to script the output of a table or plot, which can generate heatmaps, custom significance highlighting, and more.

  • New weighting facility - enter targets as percentages, handles new waves of trackers, automatic rim weighting (combines multiple weight targets), enter targets that vary by month.

  • Fetching raw data from SQL databases.

  • Find relationships between variables: right click and choose Trace Dependencies

  • New type of output: Text. Allows you to enter formatted text and bullet lists to be displayed in PowerPoint slides or an online dashboard.
  • Significance test highlighting and column comparisons are now customizable: arrow size, text color, text size and column names can be customized at specific p-value cutoffs.
  • QScripts are new Office-like macros for Q, allowing you to modify variables and questions and customize your tables and plots using JavaScript.

  • Improved varimax rotation algorithm in Principal Components Analysis.
  • Fixed bug in significance testing for trend plots.
  • Changed treatment of dates in Complicated Binary Variables. Missing values are now always returned as false. Previously treated as less than all other dates.

  • Q can update the data in exports to PowerPoint and Excel, leaving your slides and changes intact.

  • Many new plot types.
  • Multiple data files can be loaded into a Q project.
  • Time series can show two series from different data files (e.g. advertising spend and customer satisfaction).
  • Upload a Q project to an online dashboard via File | Share as Dashboard. (Dashboards purchased separately.)
  • The names of statistics can now be customised (e.g. 'NPS' instead of 'Average'); see the Output Text tab in either Project Options or Table Options.
  • Statistical assumptions (including multiple comparisons method of significance testing) can now be set per table.
  • Sorting by statistics now works on multiple tables at once.
  • Office 2007 and later: titles are now included in exported charts. You can turn them off using templates.
  • Improved support for dates and times in Excel-style and JavaScript formulas.
  • Ability to copy selected cells from Q to Excel.
  • Custom text may be entered into table footers.
  • Coded questions now show spans and sub-NETs for parent codes in the codeframe.
  • Text variables which are converted to Categorical variables by Q will now update seamlessly with new text responses.

  • Shift+F3 changes case of selected labels similar to Word.

  • New question type Pick Any - Compact.
  • New Tables Tab feature - View | Hide Empty Rows/Columns.
  • May edit time series analysis (smoothing) options in Date crosstabs.
  • Ability to check out transferable licenses from Q.
  • List of deleted cases that can be individually restored via the Data Tab.
  • Trees can now handle all categorical and numeric variables.
  • Improvements in planned significance tests.
  • Pairwise comparisons between different columns in a table.
  • Improvements in the way that sample size is presented.
  • Moving averages on statistics in tables.

  • Q runs in 64-bit mode on 64-bit editions of Windows; can handle bigger tables, bigger data files.
  • Analysis outputs improved - may now copy and paste output tables to Excel.
  • Merge Pick One and Pick Any questions by right-clicking in the Variables tab and selecting Insert Ready-Made Formula(s) | Merge Questions.
  • You may Undelete categories from a table while still retaining any merging or netting already done.
  • The method for computing the number of degrees of freedom in ranking questions has been modified; please e-mail Q Support for more information.
  • Automatic tests of significance have been improved for Date questions; please e-mail Q Support for more information.

  • You can drag variables, questions and tables between open Q projects. Not all types of variables and tables are supported.

  • JavaScript variables are faster. (This includes banner questions.)
  • Q can export to XtabML, used by E-Tabs.
  • Statistical tests for the whole table may be exported to Excel (click File | Export to Office, then Advanced button).
  • The Excel-style formula functions SEARCH, FIND and REPLACE have been added.
  • New hotkey to lock and unlock tables (Ctrl + L).
  • Coding: text responses can be sorted by number of responses.
  • Exporting raw variables to Excel is much faster.

  • Multiple correspondence analysis available by clicking Create | Map.

  • Q can now use data from Triple-S (.sss) files.

  • The new Q Online Training system is now available from the Help menu.

  • Ability to automatically update license when renewal invoices are paid.
  • No requirement to be Administrator when activating or deactivating license.
  • Modified significance tests for Pick Any - Grid and Number - Grid questions (previously known as Two Dimensional questions); they now produce significance tests of NET and SUM.

  • A new software licence agreement which contains a clause that protects both parties in regards to confidential information, so that you can send bug reports to us containing your client's data, and it will be kept in confidence.

  • New question types: Experiment, Ranking, Date.
  • Tools | Save Data as SPSS .sav File
  • Tools | Convert .sps File to .sav
  • Tools | Merge Data Files | Add New Cases
  • Tools | Merge Data Files | Add New Variables
  • Toggle multiple table statistics by holding down Ctrl.
  • Segmentation (or classification) trees, in the Create menu.
  • Time series plots, in the Create menu.
  • Use <filter> and <weight> in table or group names, and they will be replaced with the actual filter and weight labels upon exporting.
  • Spans included in Excel exports of tables.
  • Copy and Paste Question(s) in the Variables and Questions tab.

  • An important bug fix: in some tables, the 'Sample scaling constant' from 'Analysis | Statistical Assumptions...' was ignored.

  • Shortcut (Ctrl + I) to select all variables in a question in the Variables and Questions tab.

  • The way chart templates work has changed. Go to User Options and reconfigure them.
  • Q works with Office 2007 chart templates.
  • Chart templates can be set for individual tables.
  • Effective sample size now computed for each cell in a table. Effective sample size shown at the bottom of the page is the largest of these.

  • Medians, quartiles and trimmed averages.

  • Support for Money-type variables and symbols.
  • Extra missing values identified in SPSS files are now understood.
  • Improved automatic setup of two-dimensional questions.
  • Turn statistics on or off for multiple tables at once in the Report tree.
  • Choose if and where SUMMARY/frequency tables get output from Basic Tables.
  • New Variables and Questions Tab operation: Combine (Binary) Variables.
  • Ability to find variables in Data Tab (shortcut: F5 key).

  • A Data tab to view, edit and sort raw data, and to create variables using Excel formulas (e.g., =Q2+Q7).
  • Multiple filters on a single table.
  • Table styles, which control the appearance of tables on screen and when exported.
  • Advanced regression, including an expert system to select the appropriate test.
  • Latent class analysis, which forms segments using both numeric and categorical data.
  • Rim weighting.
  • Tidy categories in a table by sorting categories and Search/Replace...
  • Q projects can be read into R.
  • Convert an unstacked SPSS data file into a stacked SPSS data file.
  • New categories can be added to a banner question.
  • Spans can be used to show different groups of categories in a question (e.g., within a banner question).
  • Additional variables can be pasted from Excel.

  • Percentages in Q are exported to Excel as formatted percentages, when you display % signs in a table in Q. Please check any automated workbooks that use these values.

  • Better handling of large data files.

  • Row and column statistics.
  • Exporting to Microsoft Word.
  • Improved report print-outs/PDFs, with scaled bar graphs and cell colouring.
  • Separate control of decimal places for each data series.
  • Recoding ranges of variable values using rules.
  • Cover pages on printed/PDF reports.
  • Table of contents in printed/PDF reports and optionally in Excel exports.
  • Customisable PowerPoint exports.

  • Improved Cluster Analysis algorithm.

  • Basic Tables feature, available from 'Advanced | Basic Tables...'

  • Ability to import/export codes in your coded variables (via the right-click context menu in the code editor).
  • Ability to 'tag' questions so they may be used as filters, weights, or be hidden from the blue and brown dropdowns.

  • Ability to view simple statistics of all variables via View | Show Statistics.
  • Ability to add Comments to variables in the Variables and Questions tab (via right-click menu).
  • Coding module, now available to all licensed users.
  • Moon plot option for Correspondence Analysis.
  • Drag and dropping of variables in the Variables and Questions tab.

  • Ability to export raw data using 'File | Export Selected Variables to Excel...'


  • Customisation of print/PDF report fonts.
  • Ability to export project and data file as a package to clients using 'File | Send Package'.


  • Ability to control the layout of two-dimensional questions.
  • Ability to rename variable labels using search and replace.


  • Ability to provide templates for exporting charts to Microsoft Office.


  • Ability to customize default Office chart types (available through 'Edit | Default Export Options...').
  • Enhancements to Office exporting.


  • Enhanced Office chart appearance.
  • Ability to 'link' variables (right-click on a variable and select 'Construct New Variable(s) | Linked...').
  • Faster start-up time.
  • Web version check, available through 'Help | Check for New Version'.
  • Locking of Q project files during editing - prevent other people editing your project at the same time.
  • Ability to tell Q what to do with new variables from a data file.


  • Compatibility with Windows Vista.


  • License information is now shown in the About dialog.


  • Currently selected filter is now included in new filter when you press the "Create filter variable" toolbar button.
  • New icons for menus.


  • New icons for all types of variables and questions.


  • New Smart Tables feature, available from the Advanced menu.
  • Type-ahead search boxes - added to the Variables and Questions list, as well as the Binary and Computed variable constructors.
  • Improved appearance of toolbars.


  • Added Computed Text Variables, so you can combine multiple text variables into one by joining together their responses (see Help for an example).


  • Added ability to create filters from selected table cells (click on the filter toolbar button).
  • Added ability to import SPSS for Mac files.


  • "Create Banner Question" added; available from the Advanced menu.


  • Improved handling of changes to data files.
  • Online help added.


  • Updated manuals, tutorials and reference guides.
  • Improved validation when constructing variables.

Further reading: Key Driver Analysis Software