topic Re: Need help for Pie chart color in QlikView

Need help for Pie chart color

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

Hi All,

I need your help to create the pie chart as attached. The blue color shows the region 1 and and it has many countries with in it. same for all the colors. Thanks in advance.

Re: Need help for Pie chart color

prma7799 — Thu, 25 May 2017 09:43:16 GMT

Please share some sample app

Re: Need help for Pie chart color

Sergey_Shuklin — Thu, 25 May 2017 09:59:34 GMT

Hello!

If you use a country as a dimension you can set this expression for background color of your chart:

if(region=1,rgb(x,x,x),if(region=2,rgb(y,y,y)... and so on. It can help if you don't have a lot of regions.

Re: Need help for Pie chart color

Anonymous — Thu, 25 May 2017 10:11:15 GMT

Please post sample data

Re: Need help for Pie chart color

amit_saini — Thu, 25 May 2017 10:51:53 GMT

Hi,

Please try something similar :

So in ur case for Region as Dimension try background Color as below:

=if(Region='A',rgb(141,170,203),if(Region='B',rgb(252,115,98), if(Region='C',rgb(187,216,84))))

Thanks,