topic Re: How to keep the same color concurrently to an expression ? in QlikView

How to keep the same color concurrently to an expression ?

yanivvl0 — Thu, 14 Apr 2016 08:04:26 GMT

hi to all ,

i have a BlockChart and a BarChart , and they are "talking" to each other as you can see here :

the colors in the 2 charts are applicable to the numbers ( green blue ) of the expression , the problem is :

when we click on 2010 wich have only green - the color in the BlockChart is changing to blue :

How can we keep the color green for the green_flower ? thanks.

Re: How to keep the same color concurrently to an expression ?

Chanty4u — Thu, 14 Apr 2016 08:07:25 GMT

Hi,

Instead of that.

u can set ur colur values in colors tab.... by that it will show for first clr fr frst value ....and so on..

Re: How to keep the same color concurrently to an expression ?

Gysbert_Wassenaar — Thu, 14 Apr 2016 08:14:01 GMT

In both charts click on the + in front of the expression, select background color and use an expression like:

pick(match( FlowerColor, 'green_flower', 'blue_flower'), green(), blue() ).

Replace FlowerColor with the name of the dimension than contains the values green_flower and blue_flower. Replace green() and blue() with the colors you want. If for example you set the colors in your palet on the colors tab you could use something like color(1) and color(2) to get the first and second color of the palet. You can also use the RGB(R,G,B) function.

Re: How to keep the same color concurrently to an expression ?

yanivvl0 — Thu, 14 Apr 2016 08:40:35 GMT

hi Gysbert , i did the first step , and i am stuck , dont understand , do i need to add to the model a table of color dimension ?

can you show a picture ?

regards.

Re: How to keep the same color concurrently to an expression ?

Gysbert_Wassenaar — Thu, 14 Apr 2016 08:53:08 GMT

See attached qvw

Re: How to keep the same color concurrently to an expression ?

yanivvl0 — Thu, 14 Apr 2016 09:09:37 GMT

hi Gysbert , yes , now i can see the solution - THANKS!