Reverse the order of 2 linked dimensions in a pivot table

[Yasmine_Alaoui]

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!

[Clement15]

Hello,

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

[Yasmine_Alaoui]

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 :

(The categories are in upper cases)

But when I switch them it becomes like that :

The category is repeated for every subcategory associated to it.

[Clement15]

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

[Yasmine_Alaoui]

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]

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