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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Merging rows in Pivot table

Would like to merge cells in Pivot table, sample design attached below for reference.

Basic Pivot design:

Pivot_design.png

Requirement is to merge cells and expected to design like,

Expected_Design.png

Would like keep Abc - Total & Fun - Total expressions as columns and not to show duplicate for each rows.

3 Replies
swuehl
MVP
MVP

Can you please check your screenshots, I can't see any image.

Maybe you are using links to images that can't be accessed by unauthorized users.

If possible, please also post a small sample QVW.

Not applicable
Author

Plz check now. Attached the screenshot..I did the design in Excel to share with this group. I dont have any QVW file.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

That's not possible. You can try calculated dimensions instead of expressions, but then they would show up on with the other dimensions on the left side of the pivot table. A calculated dimension would look something like =aggr( ...original_expression_here... , Col1, Col2, Col3, Col4).


talk is cheap, supply exceeds demand