Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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..
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.
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.
See attached qvw
hi Gysbert , yes , now i can see the solution - THANKS!