Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a Pivot Table with a few dimensions, i want to be able to change the background colour of the expression based on which group it falls into under the last dimension, so in pseudo code
if leg (Dimension) = 'Transferred in' then colour1
if leg = 'Primary' then colour2
Try like this
Expression > Background Color
Replace RGB with your colors.
Try like below,
You can also do this in Expression > Background Color
If (dimensionallity() = 0, blue(), if (dimensionallity() = 1, green(), if (dimensionallity() = 2, yellow(), red() )))
dimensionallity = 0 is the most left level, you can create a expresion with = dimensionallity() to check the correct level.
Hope this helps you
Thanks for this, i actually got it right using a combination of Dimensionality() and wildmatch()
Hi Stephen Naude
I'm glad for this, then mark one answer as 'Correct answer' and other as 'Helpfull answer' to close the post.