topic Coloring expression header of Pivot Table in QlikView

Coloring expression header of Pivot Table

Anonymous — Tue, 25 Jul 2017 14:50:37 GMT

Hi community,

I try to achieve different colors in the expression headers for a pivot table like that

sample data:

LOAD * INLINE [
F1, F2
1, 10
2, 20
3, 30
4, 40
5, 50
];

"Custom Format Cell" didn't work, because I need different colors.

Any ideas or workarounds?

sunny_talwar — Tue, 25 Jul 2017 15:31:28 GMT

May be make it a dimension

Anonymous — Tue, 25 Jul 2017 16:08:10 GMT

Hi Sunny, thanks for your answer!.

I know that approach yet, I just hoped, that there's an alternative way with expressions only...