Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

yashcena
New Contributor II

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