topic Re: Colors in Chart in QlikView

Colors in Chart

gautik92 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Colors in Chart

Chanty4u — Thu, 02 Feb 2017 11:47:36 GMT

Hi,

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

Re:Load colour

Re: Colors in Chart

vinieme12 — Thu, 02 Feb 2017 11:54:39 GMT

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

Re: Colors in Chart

sravanthialuval — Thu, 02 Feb 2017 11:55:50 GMT

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

Re: Colors in Chart

ramasaisaksoft — Thu, 02 Feb 2017 12:05:24 GMT

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.

Re: Colors in Chart

Anonymous — Thu, 02 Feb 2017 12:08:10 GMT

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

Re: Colors in Chart

gautik92 — Thu, 02 Feb 2017 12:27:18 GMT

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

Re: Colors in Chart

MarcoWedel — Fri, 03 Feb 2017 00:25:49 GMT

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

Re: Colors in Chart

gautik92 — Fri, 03 Feb 2017 04:30:28 GMT

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

Re: Colors in Chart

MarcoWedel — Fri, 03 Feb 2017 21:59:11 GMT

please post a sample application to test with

thanks

regards

Marco