Pivot Table Enhancements

[Jennell_Yorkman]

In this blog post, I will cover some enhancements that have been made to the Pivot table. The Pivot table is like a Straight table in that it takes multiple dimensions and measures, but what makes it stand apart from the Straight table is that the columns and rows can be reorganized providing various views and subtotals. The Pivot table can be found in the Qlik Visualization bundle under Custom objects.

The styling option continues to improve, giving the developer flexibility in styling the header, dimension, measure, total and null values in the chart. Text and background colors can be adjusted based on an expression as well. Rows can be indented, which I like because it looks more compact and takes up less space on the left.

Indented

Not indented

As you can see in the images above, a row can be presented as a link by changing the Representation to Link and adding a URL.

Indicators can also be added to cells alongside the text to call the user’s attention to something. For example, in the image below, a red yield indicator is shown when the sales value is less than 1,000 and a green dot is shown when the sales value is greater than 20,000.

Right-to-left support is available in the Pivot table as well for those who read right-to-left.

This setting can easily be toggled in the Settings of an app in the Appearance section.

While in view mode, rows and columns can be expanded or collapsed by either clicking the – or + sign or by opening the menu and selecting collapse or expand. From the menu, the sort order, search and selections can also be set.

Another enhancement of the Pivot table is the ability to use a cyclic dimension for the rows or columns. In the Pivot table below, a cyclic dimension with 3 fields (Category Name, Product and Product Name) is used for the rows. Notice that only one field of the cyclic dimension is visible at a time.

From the Pivot table, the cyclic dimension can be changed by opening the menu and selecting the desired dimension. To learn more about cyclic dimensions, check out one of my previous blog post.

Try out the Pivot table (found in the Visualization bundle) the next time you are developing an app to make use of the new enhancements. Check out Qlik Help for more information on the Pivot table and take a look at the What’s New app to see the Pivot table used in this blog post.

Thanks,

Jennell

[QFabian]

nice update, thanks @Jennell_Yorkman 

[mshann01]

These are welcome enhancements but when are we going to be able to export the total rows in straight and pivot tables to excel like in QV and QSEoW?  That's been on the ideation request for years with little traction and it's an important feature.  Extensions solve for this but can't be exported to reports.  Why can Vizlib do it but Qlik can only do it on prem?

[blaise]

We're close to catching up with all the features from the pivot table in qlikview.

GG!

[Msandeepkumar]

Good feature@Jennell_Yorkman 

[mikaelsc]

great enhancements, but still waiting for being able to pivot/reoarganise dimensions in the pivot table... 🙄

[Mark_Miron]

Is this something the is in the May 2025 release for Enterprise?

Also it is unclear in the article, has the expand and collapse functionality been enhanced at all here or is this only access to it in the drop down? Are we able to expand or collapse all at the dimension level now? Previously you could expand or collapse everything or one row at a time, a more nuanced functionality is be appreciated.

Thanks!