Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sure it's possible. PFA the app.
regards
Pratyush
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!
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
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
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