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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
k_burata
Creator
Creator

Cell merge in pivot chart

Hi all,

I need to merge cells inside a pivot table, is the scenario below possible in QlikView or do I have to modify my model?

Cheers,

Capture.PNG

1 Solution

Accepted Solutions
hubertdudek
Contributor III
Contributor III

you can not merge cell

1) you can make custom format and disable border for that cells.

2) you can play with "above"/"below" functions to move numbers down and up

View solution in original post

5 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can't merge pivot table cells. Qlikview is not a spreadsheet application.


talk is cheap, supply exceeds demand
hubertdudek
Contributor III
Contributor III

you can not merge cell

1) you can make custom format and disable border for that cells.

2) you can play with "above"/"below" functions to move numbers down and up

k_burata
Creator
Creator
Author

How about to this?

Capture.PNG    

Am I able to do this using a calculated dimension or do I do it on the script?

Thanks

florentina_doga
Partner - Creator III
Partner - Creator III

use function concat

florentina_doga
Partner - Creator III
Partner - Creator III

use concat(distinct employees,',') in expressions