Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Yasmine_Alaoui
Partner - Contributor II
Partner - Contributor II

Reverse the order of 2 linked dimensions in a pivot table

Hello everyone,

I am working with a pivot table in Qlik Cloud where I display both a "Category" dimension and another "Subcategories" dimension underneath. Currently, the display is structured with "Category" first, followed by the "Subcategories." However, I want to reverse this order so that the subcategories appear first, followed by the category.

Could anyone guide me on the best way to change the display order of dimensions in this pivot table?

Thanks in advance for your help!

Labels (3)
5 Replies
Clement15
Partner - Specialist
Partner - Specialist

Hello,

You can change the order of the dimensions by dragging them one above the other.

 

Clement15_0-1736440231315.png

 

Yasmine_Alaoui
Partner - Contributor II
Partner - Contributor II
Author

Hello Clement,

It's the first thing I did, but the thing is that I have multiple subcategories, so when I switch the two, I have duplicate Categories. 

This is what I have :

Yasmine_Alaoui_0-1736440818725.png

(The categories are in upper cases)

But when I switch them it becomes like that :

Yasmine_Alaoui_1-1736440928942.png

The category is repeated for every subcategory associated to it.

Clement15
Partner - Specialist
Partner - Specialist

I thought I understood that this is what you wanted. How do you want to display your dimensions then?

Yasmine_Alaoui
Partner - Contributor II
Partner - Contributor II
Author

No I just want the subcategories first then the category, look at the first picture, for example I have a category followed by 3 of its subcategories, the aim is that I want the 3 subcategories followed by the category. Theoretically it’s simple but I cannot find how to do it 😭

Clement15
Partner - Specialist
Partner - Specialist

I don't think this is possible. The only possible customization is removing the indent in the presentation options.