Pivot adding column custom header

[ffcrafael]

Hello Fellow Qlik user,

I'm new to Qlik pivot table, I want to know if there's a way to create exactly like 'CURRENT MONTH', 'PREV MONTH' 'YTD' headers on Qlik Sense pivot table? 🙂

Best regards,

rafael

[Gysbert_Wassenaar · Accepted solution]

Probably not.
Perhaps by creating a dimension with these values and then adding that dimension to the pivot table.

That dimension should come from a table looking something like this:

PivotHeaders:
LOAD * INLINE [
HeaderDimension, MetricDimension
CURRENT MONTH, TARGET
CURRENT MONTH, ACTUAL
CURRENT MONTH, PERF
C.Month, Growth vs PREV Month
CURRENT MONTH, TARGET
CURRENT MONTH, ACTUAL
CURRENT MONTH, PERF
YTD, TARGET
YTD, ACTUAL
YTD, PERF
];