Colors in Chart

[gautik92]

I have a scatter chart with more than 20 values those colors are repeating cos of more than 20 values

i need to write a condition for expression background dynamically assign different colors

any ideas?

[Chanty4u]

Hi,

Am not sure about it but may be this helps you please click on below link

Re:Load colour

[vinieme12]

You will need to do it with Pick(Match( or   IF's  or see my post here.keep a color joined to a value

If you try to do it dynamically then the colors will keep changing on selections or everytime the object calculates

[sravanthialuval]

Hi,

Try this it may be helpful .By using monochrome effects you can achieve same color with different shades based on the value.Please find below link.

Using ColorMix In Qlikview

[ramasaisaksoft]

I am not sure Gowtham,

but try with the help of  excel values  calling with variable.

else

you need to write Nested if - else statements.

[Anonymous]

Hi Kesavan,

Yes dynamically assigning color is possible , follow the steps listed below

Step1) Create a  Inline statement to define RGB colors for each 20 values and reload the app

Step 2)In UI :

Scatter chart : Click on expression 1 + symbol you will find Background color editor, Enter expression as rgb(R,G,B)

Hope this helps you and attached demo app also

[gautik92]

that is not possible as i am having n number of values

[MarcoWedel]

what information do you expect your users to retrieve from a chart having 20+ different colors?

[gautik92]

In this chart i am having more than 20 vendors but in color pallette we have oly 18 colors after that color will get repeated .

now my requirement is color should not get repeated

[MarcoWedel]

please post a sample application to test with

thanks

regards

Marco