Merge Column Header in Charts/tables

yashcena — Tue, 14 Nov 2017 09:09:34 GMT

I have a pivot table which looks somewhat like this:

(illustration from excel)

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

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

topic Merge Column Header in Charts/tables in QlikView

Merge Column Header in Charts/tables