Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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