Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
];
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
];