topic Re: Change individual column header background in QlikView

Change individual column header background

yashcena — Wed, 04 Oct 2017 08:18:36 GMT

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

Re: Change individual column header background

prat1507 — Wed, 04 Oct 2017 10:29:39 GMT

Sure it's possible. PFA the app.

regards

Pratyush

Re: Change individual column header background

yashcena — Wed, 04 Oct 2017 10:40:29 GMT

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!

Re: Change individual column header background

prat1507 — Wed, 04 Oct 2017 11:46:31 GMT

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

Re: Change individual column header background

yashcena — Thu, 05 Oct 2017 06:39:19 GMT

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

Re: Change individual column header background

prat1507 — Thu, 05 Oct 2017 07:30:15 GMT

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