Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Troubleshooting Group/Ungroup feature in pivot tables

Hi team,

Hoping for your assistance once again.

I have been able to consolidate expressions and group them in my pivots ($ vs qty). However it seems to fail with this table.

1 Solution

Accepted Solutions
boorgura
Specialist
Specialist

You lose the ability to cycle thru expression group when you pivot a dimension across.

As per my knowledge, I dont think there's a clean solution.

However - you can Add a dummy expression (='') with blank label (space), and reduce the column width to minimum.

Definitely not a clean solution!

PS: the dummy expression should not be grouped along with the other expressions

View solution in original post

1 Reply
boorgura
Specialist
Specialist

You lose the ability to cycle thru expression group when you pivot a dimension across.

As per my knowledge, I dont think there's a clean solution.

However - you can Add a dummy expression (='') with blank label (space), and reduce the column width to minimum.

Definitely not a clean solution!

PS: the dummy expression should not be grouped along with the other expressions