Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Manipulate the color of the pie's of a piechart

Gents,

I used this piece of coding in a chart to alter the background colour (on expression) of a pie but all turns into black.

if(GetCurrentField(#TEST) = 'R', rgb(0,128,0),
      if(GetCurrentField(#TEST) = 'A', rgb(255,255,0));

has onyone an idea how to get the right colours?

BR

M.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Manipulate the color of the pie's of a piechart

Hi,

     Try this.

    

if(#TEST = 'R', rgb(0,128,0),
      if(#TEST = 'A', rgb(255,255,0));

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Manipulate the color of the pie's of a piechart

Hi,

     Try this.

    

if(#TEST = 'R', rgb(0,128,0),
      if(#TEST = 'A', rgb(255,255,0));

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
sushil353
Honored Contributor II

Re: Manipulate the color of the pie's of a piechart

is #Test is your field name? and 'R' , 'A' are the values of the field #TEST...?

Try this

if(GetFieldSelections(#TEST) = 'R', rgb(0,128,0),

      if(GetFieldSelections(#TEST) = 'A', rgb(255,255,0));

HTH

Sushil

Highlighted
Not applicable

Re: Manipulate the color of the pie's of a piechart

Thx Gents!!

All working now...