topic Dimension colors in pivot in QlikView

Dimension colors in pivot

Wed, 25 Jul 2012 09:05:16 GMT

Hi,

How to set different colors for single dimension values in pivot table.

Brands is the field having Brand1 India,Brand2 US, Brand3 India etc.

now the country "India" brands should be in "green color" and other should be in "blue color".

how can i do it in pivot table ? And my pivot table should be same as like below image.

Thanks in advance.

Re: Dimension colors in pivot

Wed, 25 Jul 2012 12:55:02 GMT

Hi,

in charts properties --> used dimensions --> check the plus to get the expression editor to enter a condition for the background color of the according dim: (my exam-dim is "DimensionName"):

=if(DimensionName like '*India*', LightGreen(), Lightblue())

HtH

Roland

Re: Dimension colors in pivot

Wed, 25 Jul 2012 13:42:22 GMT

Hi Roland,

I tried this, it's not working in pivot table but it is working in straight table.

Why it is happening ? or any other way to do it.

Thanks in advance.

Regards,

Venkat

Re: Dimension colors in pivot

Wed, 25 Jul 2012 14:38:45 GMT

Hi Venkat,

this should work in both chart-types fine. I am personally using it several times. So check for syntax etc. BTW: which Version do you have? I use QV11 SR11.

Re: Dimension colors in pivot

Wed, 25 Jul 2012 15:28:16 GMT

Hi Roland,

I'm using QV11 SR1.

Please find the attached sample app.

Thanks in advance.

Regards,

Venkat

Re: Dimension colors in pivot

Wed, 25 Jul 2012 15:47:01 GMT

Hi Venkat,

as I told you: Check for syntax etc. Or do you got a country like India in your country field ? 😉

So try the code below for matching all countries that include "Ireland" in their names:

=if(Country like '*Ireland*', LightGreen(), Lightblue()) // pattern is Ireland !!