Crosstab Analysis in Survey Reports
Crosstabs help you compare one survey answer against another. Use them when you need to answer questions like, “How did purchase intent differ by age group?” or “Do promoters and detractors answer this concept rating differently?”
In Quali-Fi, crosstabs are available in two places:
- Cross Tabs workspace — a dedicated analytics page for building, saving, sharing, and exporting individual tables
- Report builder — crosstab blocks on saved report slides alongside charts and text
Both use the same configuration dialog and table rendering. Use the workspace when you only need tables; use the report builder when you need a full slide deck.
Dedicated Cross Tabs workspace
Open a survey and go to Analytics. Click Cross Tabs in the analytics top bar (or choose Cross Tabs from the analytics navigation).
The workspace includes:
- Configure — open Configure cross tab to pick stub (rows) and banner (columns), metrics, filters, significance, and display options
- Filters — response status, date range, saved filters, and test responses (panel title: Cross Tab Filters)
- Saved cross tabs — sidebar list of named tables you saved for this survey
- Save / Save as — store the current table setup and filter snapshot
- Rename cross tab / Save cross tab dialogs when creating or updating a saved name
- Download — export the current table to Excel (
.xlsx) - Share — create a share link for a saved cross tab so stakeholders can view the table without a Quali-Fi account
- New — start a fresh configuration without loading a saved table
Saved cross tabs keep the table setup and filter snapshot so you can reopen, edit, or share them later. When you change filters or configuration, use Refresh table to regenerate results.
Note
Crosstabs in the report builder are still available under Analytics → Report. Blocks you added before the workspace existed continue to work the same way.
Crosstabs in the report builder
Each crosstab in the report becomes a slide block that can be saved, refreshed, shared with the report, or exported to Excel.
Before you start
- Your survey should already have responses.
- Open the survey from your organization dashboard.
- Go to Analytics → Report (for report blocks) or Analytics → Cross Tabs (for the dedicated workspace).
- Use completed responses by default unless you intentionally need terminated, quota full, test, or all response statuses.
Note
Crosstabs use survey questions as the row and banner variables. Open-ended text questions are not designed for crosstab rows or banners unless they have first been converted into structured categories elsewhere in your workflow.
What a crosstab shows
A crosstab table has:
- Rows: the answer categories you want to compare, such as satisfaction score, NPS group, product choice, or a demographic question.
- Banner: the segment shown across the columns, such as age group, gender, region, plan type, or another categorical question.
- Cells: the counts, percentages, weighted counts, or means for each row-by-column combination.
- Base sizes: the number of respondents behind each row or column.
The most common setup is a row question by a banner question with Counts and Column % turned on. Column percentages answer, “Within this segment, what share selected each row option?”
Add one crosstab
Open the survey and go to Analytics → Report.
In the left panel, expand Elements.
Click Cross Tabs, or drag it onto the current report slide.
In Configure Crosstab, choose a Rows question and a Banner question.
Adjust the base, filters, metrics, sorting, significance, or template settings as needed.
Click Apply Crosstab.
The crosstab block is added to the active slide. Quali-Fi generates the table from the latest matching survey responses and gives the block a title based on the selected questions, such as “Purchase Intent by Age Group.”
Choose rows and banners
The Rows field is the main question you want to analyze. Rows can use categorical questions and supported numeric-style questions.
Common row choices include:
- Single choice
- Multiple choice
- Dropdown
- Yes/No
- Likert 5
- NPS
- Rating
- Matrix and matrix multi
- Number, slider, and other supported numeric questions when you want to show means
The Banner (columns) field is the segment across the top of the table. Banner questions should be categorical, such as single choice, multiple choice, dropdown, Yes/No, Likert, NPS, rating, matrix, matrix multi, or supported custom questions.
Computed lists and embedded data can be either the stub or the banner. The configure dialog says so: choose a stub and a banner, and computed lists and embedded data can be used as either.
Under Advanced options, Banner variables lets you add more than one banner. The layout is Nested or Side by side.
- Nested crosses the banners, the way “Region / Age Group” stacks one breakdown inside another. Two banners is the practical limit. Once you add a third, Quali-Fi stores the table as Side by side.
- Side by side places each banner’s columns next to the others. That is the layout to use with three or more banners. The help under Banner variables says the same thing.
Stub book (optional) puts several stubs under that one banner: the current stub stays selected, and each extra stub you check becomes its own table. Bulk Crosstabs is the shorter path when you want one table per row question and you are fine with the default setup. Use the stub book when you are already inside Configure cross tab and want those tables to share the banner you just built.
Still in Advanced options:
- Banner title — a heading over the banner. The field’s placeholder is Header 1.
- Total column label — renames the total. The placeholder is All.
- Show column numbers and Show question numbers — optional row labels for the sheet.
- Stack row — a second row variable on a single table. It is hidden once the stub book has more than one stub.
Include Total column adds an overall column on the left. It is off by default, and significance letters do not use it.
Tip
Nested banners multiply columns fast. Side by side keeps each banner readable when you have three or more. A few focused tables still beat one sheet nobody can present.
Pick the right base
The Base setting controls the denominator used for reliability and percentage context.
- Answering: uses the base for respondents who answered the relevant row question. This is the default and is usually right for question-level analysis.
- Total sample: uses the total filtered response base.
- Segment: uses the banner column base.
Each table also shows the overall base and generated timestamp under the table. Row and column headers show their own base counts.
Set a minimum base
Use Min base to suppress cells when the configured base is too small. Suppressed cells display as Suppressed instead of showing a potentially misleading value.
This is useful when:
- a segment has very few respondents,
- a nested banner creates tiny groups,
- you are sharing the report outside the research team,
- or you want to enforce a minimum reporting standard.
Click a crosstab cell to open Cell Calculation Context. This view shows the row, column, count, base n, percentages, weighted count, mean, suppression status, and significance details when available.
Filter a crosstab
The Table Filters section limits a specific crosstab without changing the rest of the report.
Available filters include:
- Responses: Completed only, Terminated only, Quota full only, or All statuses.
- Start date and End date.
- Include test responses.
By default, crosstabs use completed responses and exclude test responses.
Warning
Only include test responses when you are validating the table setup. Remove test responses before sharing final reporting unless your team has a specific reason to include them.
Choose metrics
Every crosstab includes Counts. You can add:
- Column %: the share within each banner column. Best for comparing segments.
- Row %: the share across each row. Useful when the row is the base and you want to see how it splits across columns.
- Total %: the share of the filtered total base.
- Weighted counts: available when you select a numeric weight question.
- Means: available when the row variable is numeric.
For multiple-choice row or banner questions, open Configure cross tab and set Multi-select percent base:
- % of respondents — column percentages use respondents as the base (default)
- % of mentions — column percentages use total mentions when respondents can select more than one option
If a metric is not valid for the selected setup, Quali-Fi disables it. For example, Weighted counts requires a selected weight question, and Means requires a numeric row variable.
Use weights
The Weight field lets you choose a numeric survey question to use as a weight variable. Weighted counts are only calculated when a valid numeric weight question is selected.
If a respondent has a missing, invalid, or negative weight, that respondent is excluded from weighted counts. Quali-Fi shows a warning below the table when this happens.
Note
Embedded-data weights are not currently available in the report builder crosstab UI. Use a numeric survey question as the weight source.
Add top-box, bottom-box, or detractor nets
For score-based questions such as Rating, NPS, and Likert 5, Quali-Fi can add common category nets.
Depending on the selected question type, you may see:
- Add top-box net
- Add bottom-box net
- Detractors for NPS-style bottom grouping
- Category checkboxes to hide individual score values
These nets are added alongside the original categories unless you hide individual categories. This is useful when a stakeholder wants both the full score distribution and a summary measure such as Top 2 Box.
Sort rows and columns
Use Row Sort and Column Sort to control table order:
- Question order: keeps the original survey order.
- Label A-Z: sorts alphabetically.
- Base high to low: puts larger groups first.
- Base low to high: puts smaller groups first.
Question order is often best for final reporting because it matches the survey design. Base sorting is useful during exploration.
Run significance testing
Turn on Run significance testing when you want Quali-Fi to compare banner columns.
Available settings:
- Confidence: 90%, 95%, or 99%.
- Correction: None, Bonferroni, or Holm.
- Display: Letters, Highlight, or Both.
When significance is detected, Quali-Fi marks cells that are significantly higher than another column. Letter markers refer to the compared column. Click the cell to see p-values and calculation context.
On a Side by side banner, those letters restart inside each banner and the test compares columns inside that banner. A side-by-side age banner is not tested against a side-by-side region banner on the same sheet. Nested, and a single banner, still compare across the columns in the table. The Total column is left out of the letters either way.
Use significance testing as a guide, not a substitute for research judgment. Small bases or a lot of columns can produce results that need a careful read.
Save and reuse templates
The Saved Templates section lets you save a crosstab setup in your browser.
To save a template:
Configure the crosstab.
Enter a Template name.
Click Save Template.
To use a template later, choose it from Saved Templates and click Apply Template.
Templates are stored in the browser you are using. They are useful for your own repeat workflows, but they are not organization-wide templates.
Create bulk crosstabs
Use Bulk Crosstabs when you want to create several tables with the same banner.
Open Analytics → Report.
Expand Elements.
Click Bulk Crosstabs.
Choose the shared Banner question.
Select one or more Row questions.
Click Add Tables.
Quali-Fi creates one crosstab per selected row question using the same banner. Bulk crosstabs use the default setup: Counts, Column %, Answering base, completed responses, test responses excluded, and no minimum base.
You can edit each generated table afterward if one needs different filters, metrics, sorting, or significance settings.
Work with a crosstab block
After a crosstab is on the slide, you can:
- Drag it to reorder it with other report blocks.
- Switch between Full and Half width.
- Click the refresh icon to regenerate the table from the current data.
- Click the settings icon to reconfigure it.
- Click the download icon to export that crosstab to Excel.
- Click the trash icon to remove it from the report.
Saving the report stores the crosstab configuration, not a frozen copy of the table. When the report reloads, Quali-Fi regenerates crosstab results from the saved setup.
Export to Excel
Use the download icon on a crosstab block to export that table as an .xlsx file. The export includes:
- row and column labels,
- count and selected percentage metrics,
- weighted counts or means when enabled,
- significance letters when present,
- notes and warnings.
The downloaded file name is based on the crosstab title.
Shared reports
Crosstab blocks are included when you save and share a survey report. Shared report links show the saved crosstab configuration with generated results, so stakeholders can view the same tables without needing access to the report builder.
If a crosstab cannot be generated in a shared report, the report shows an error message for that table instead of failing the whole report.
Troubleshooting
I cannot apply the crosstab
Choose different questions for the row, banner, stack row, and nested banner fields. The same question cannot be used in conflicting positions.
A metric is disabled
The selected setup does not support that metric. Weighted counts requires a numeric weight question. Means requires a numeric row variable.
The table is empty
Check the response status, date range, test response setting, and selected questions. A table can be empty if no matching responses answered both the row and banner questions.
Percentages add to more than 100%
This can happen with multiple choice questions because one respondent can select more than one option. Quali-Fi adds a note when multi-select rows may sum above 100%.
A cell says Suppressed
The cell’s configured base is below the Min base threshold. Lower the threshold only if your reporting standards allow it.
Weighted counts look lower than expected
Respondents with missing, invalid, or negative weights are excluded from weighted counts. Check the warning below the table and review the selected weight question.
Best practices
- Start with Counts and Column %. Add other metrics only when they answer a specific question.
- Keep banners focused. One clear segmentation variable usually beats a wide nested table.
- Use Min base before sharing results with stakeholders.
- Be careful with significance testing when bases are small or the table has many columns.
- Use Bulk Crosstabs for first-pass exploration, then edit the tables you plan to share.
- Refresh crosstabs before exporting or sharing a final report.