topic Re: pie-chart color change in QlikView

pie-chart color change

Anonymous — Mon, 19 May 2014 15:08:23 GMT

Hi All,

Can we change the color of Pie chart on the basis of their relative percentage like if a field has a highest percentage should have fix color and so on.

My case is dynamic and highest percentage owner changes on different selection

Thanks

Manish Madan

Re: pie-chart color change

Mon, 19 May 2014 15:50:33 GMT

Try with colormix function:

ex.

=colormix1("field name has value between 0 and 1", RGB(90, 240, 96), RGB(227, 34, 6))

Re: Re: pie-chart color change

Anonymous — Mon, 19 May 2014 15:59:17 GMT

Hi Mario,

I tried but i could not do so.

could you please try to implement,please find the attached .qvw !

Re: Re: Re: pie-chart color change

Mon, 19 May 2014 16:08:12 GMT

try with colormix wizard and see the attached qvw.

Re: Re: pie-chart color change

Anonymous — Mon, 19 May 2014 16:46:25 GMT

could you please share exact condition which you wrote in colormix wizard and give me a brief of it.

Re: Re: Re: pie-chart color change

Mon, 19 May 2014 17:08:45 GMT

look this

Re: Re: pie-chart color change

Anonymous — Mon, 19 May 2014 17:26:12 GMT

Hi Mario,

I might be taking more time of yours,apologies .could you please the exact condition which you wrote in wizard because background color definition is not at all easy to understand and when i tried to back track the original condition is showing nothing and asking for new.

=colormix1("field name has value between 0 and 1(....?.....)", RGB(90, 240, 96), RGB(227, 34, 6)).

Thanks in advance

Re: pie-chart color change

crusader_ — Tue, 20 May 2014 09:29:57 GMT

Hi, Manish

Look here:

Colormix1(Value , ColorZero , ColorOne)

This function returns an RGB color representation from a two color gradient, based on a value between 0 and 1.

If value = 0 the first color is returned.

If value = 1 the second color is returned.

If 0 < value < 1 the appropriate intermediate shading is returned.

Value is a real number between 0 and 1.

So if you have calculated field which values are between 0 and 1 just put it inside, if you don't just use smth like this

sum(smth) / sum( TOTAL smth) = value between 0 and 1

Hope this helps

Andrei