Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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