topic Re: Background Colour (Based on Group) in QlikView

Background Colour (Based on Group)

Wed, 15 Jul 2015 11:22:13 GMT

Hi there,

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

else colour3

Thanks

Re: Background Colour (Based on Group)

qlikmsg4u — Wed, 15 Jul 2015 11:25:14 GMT

Try like this

Expression > Background Color

=If(Leg='Transfered In',RGB(111,111,111),IF(Leg='Primary',RGB(222,222,222),RGB(150,150,150)))

Replace RGB with your colors.

Re: Background Colour (Based on Group)

Wed, 15 Jul 2015 11:29:45 GMT

Try like below,

if(wildmatch(Leg,'Transfered In'),green(),if(wildmatch(Leg,'Primary'),red()))

Re: Background Colour (Based on Group)

Joaquin_Lazaro — Wed, 15 Jul 2015 11:36:54 GMT

Hi Stephen2014

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

Joaquín

Re: Background Colour (Based on Group)

Wed, 15 Jul 2015 12:14:07 GMT

Hi Joaquin,

Thanks for this, i actually got it right using a combination of Dimensionality() and wildmatch()

Re: Background Colour (Based on Group)

Joaquin_Lazaro — Wed, 15 Jul 2015 13:22:56 GMT

Hi Stephen Naude

I'm glad for this, then mark one answer as 'Correct answer' and other as 'Helpfull answer' to close the post.

Regards

Joaquín