Change individual column header background

[yashcena]

I have a pivot table which has 5 dimensions and 2 expression.

I want to change each header background to different color.

I went to Custom Cell Format option to change the header background, but it changes for every column

I want Step1- Mananger Assesment and both it's count to be in blue color, Step2-Employee Acknowledgement and both it's count to be in green color, so on and so forth.

is this possible in Qlikview?

I can hide all headers and place text objects on top of the chart with different backgrounds but since it's a pivot table, the pseudo-headers would go out of place when the chart is expanded.

Any help would be much appreciated!

Thanks,

YASH

[prat1507 · Accepted solution]

Sure it's possible. PFA the app.

regards

Pratyush

[yashcena]

Thank you so much Pratyush!

Can you tell me where did you do this? I couldnt figure it out.

Also, would it be possible to have background color for Subject Leader 1, Subject Leader 2,  Subject Leader 3, Subject Leader4, Count and Count% also?

Thanks again!

[prat1507]

Yeah I did it in the dimension, so go to your dimensions, add the + sign  there and add expressions into the background color.

Regards

Pratyush

[yashcena]

Hi Pratyush...The chart which I was working on had the Subtotals on Top.

When I changed it to Subtotals in Bottom, the color scheme isnt working properly.

Subtotals on Top:

Subtotals in Bottom:

Step2 and Step 3 background colors have disappeared. I am not able to figure out how the position of subtotals is affecting the background colors of only two values (step 2 and 3) and not others.

Can you please help?

Thank you!

YASH

[prat1507]

Hi Yash

This is happening coz BAILEY, GARLAND has no values for Count and Count % for Step 2 and Step 3.

What you can do here is go into the presentation tab -> disable suppress zero values.

Now go into your expressions and add text color expressions as I've done in the attached app.

Regards
Pratyush