Qlik Sense Bookmark does not save Pivot Table Layout after Dimension reordering

[Rohit-Prakash]

In Qlik Sense, bookmarks can be created with the "Include Layout State" option to capture both current selections and the layout of visual objects, such as the expanded or collapsed state of pivot tables. However, users may notice that after reloading the document and reapplying the bookmark, the pivot table does not return to the expected expanded/collapsed layout.

Resolution

To ensure that the pivot table layout is retained when using bookmarks:

• Avoid changing the structure of the pivot table after creating the bookmark.
• Ensure that dimension value order remains consistent in the data source to prevent layout mismatch.
• If changes to dimension order or pivot structure are necessary, consider creating new bookmarks to reflect the updated layout.

Cause

This behavior is due to how Qlik Sense manages the expand/collapse structure in pivot tables. Specifically:

• Qlik Sense relies on the data load order of dimension values to track and restore the expand/collapse state.
• If the order of values in a dimension changes in the source data, the original layout state stored in the bookmark becomes invalid.
• When the pivot table structure changes (e.g., dimensions are reordered, added, or removed), Qlik Sense considers it a new layout, and the previously saved layout state can no longer be applied.

Impact of Changing Dimensions in a Pivot Table

If you change the pivot table structure after creating a bookmark (such as removing or reordering dimensions):

• Qlik Sense treats this as a different visual object layout.
• The bookmark will still apply filter selections but not the layout state.
• The expand/collapse configuration of the pivot will not be restored.

Environment

• Qlik Sense Enterprise on Windows all versions
• Qlik Cloud Analytics