Skip to main content Skip to complementary content
Close announcements banner

Pivot tables

The pivot table presents dimensions and measures as rows and columns in a table. In a pivot table you can analyze data by multiple measures and in multiple dimensions at the same time. You can rearrange the measures and dimensions to get different views of the data. The activity of moving measures and dimensions interchangeably between rows and columns is known as “pivoting”.

The efficiency of a pivot table can be illustrated by comparing a regular table with a pivot table that has the same data. In the following table, you have two dimensions: Year, and Quarter (Qtr), and three measures: Number of holes played (Holes), Fairway accuracy (FIR%), Greens in regulation (GIR%), and Putt average (Putt avg).

The table shows attendance numbers and goal averages for some venues. Year is presented more than once, and it is not possible to get a good summary of the data.

Example table with mutiple identical dimension and measure entries

Here is the same data in a pivot table.

Example pivot table with redundant dimensions and measures collapsed into expandable hierarchy

As you can see, the pivot table presents the data in a much more condensed way, which simplifies analysis and comparison. Compared to the regular table, the number or rows has been drastically decreased the number of columns is five instead of six.

Example pivot table with all hierarchy entries expanded

Default settings for a pivot table

Most native Qlik Sense chart types are automatically sorted on the dimension content:

  • Numeric content is numerically sorted.
  • Categorical content is alphabetically sorted.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!