Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Pie chart help

Hi Experts,

Can any one please help me on below issue.

I am unable to apply colors to pie chart. ONLY able to apply single color.

Please help me on this when i show in auto or in color by dimension its showing like this only.

Thanks in advacne

pie chart.png

1 Solution

Accepted Solutions
bhavvibudagam
Contributor II

Re: Pie chart help

This expression is working fine.

pick(mod(rank(TOTAL column(1))-1,5)+1 ,argb(255,189,0,38),argb(255,240,59,32),argb(255,253,141,60),argb(255,254,204,92),argb(255,255,255,178))

4 Replies
sureshqv
Esteemed Contributor III

Re: Pie chart help

did you tried ?appearance--colors and legend --custom color  by dimension

sureshqv
Esteemed Contributor III

Re: Pie chart help

if not try with expression  [instead of dimension]

if(type='value1',RGB(253,208,0),

if(type='valu2',RGB(169,169,169),RGB(0,0,0)))

HarishG
New Contributor III

Re: Pie chart help

Try this in color by expression :

ColorMix1( rank(total EXPRESSION ) / NoOfRows(TOTAL) , Color1, Color2)

bhavvibudagam
Contributor II

Re: Pie chart help

This expression is working fine.

pick(mod(rank(TOTAL column(1))-1,5)+1 ,argb(255,189,0,38),argb(255,240,59,32),argb(255,253,141,60),argb(255,254,204,92),argb(255,255,255,178))

Community Browser