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: 
yashcena
Contributor III
Contributor III

Merge Column Header in Charts/tables

I have a pivot table which looks somewhat like this:

Capture.JPG

(illustration from excel)

I want 'YTD' and '10/30/2017' to be merged for capital and expense hours.

Capture2.JPG

I cannot put a label on top of the expressions because it is a pivot table so the size of the table is not fixed. Also I add (with a load * inline) new dimension and then drag it over the expressions horizontally because YTD and Last Week (10/30/2017 in this example) are 4 different expressions. So if I drag YTD over the expression, it will appear over both the yearly and weekly expressions.


Is there any way to achieve what I have shown in this snapshot above?


Thanks,

YASH

0 Replies