# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Colors in pie chart

I have this expression in a table where I am showing percentage of this expression

sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value))

I want to show pie chart as red,green,blue if the result

Dimension-

if above expression's result is  more than 111% then red

if above expression is less than or equal to 90% then yellow

if above expression's value is between 91-110% then green

Measure-

Count (profile)

Tags (2)
Labels (4)

• ### Piechart

2 Replies
Valued Contributor

## Re: Colors in pie chart

if(sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) > 1.11 , red(),

if(sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) >= 0.9 , yellow(),

if(sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) > 0.91 and sum({<Flag = {"allocation"},Resource =- {"NA"},Profile -= {"NA"}>}(Value))
/
sum({<Flag = {"capacity"}>}(Value)) > 1.11 , green()

)))

To help community find solutions, please don't forget to mark as correct.
Valued Contributor

## Re: Colors in pie chart

This solution helped you?

To help community find solutions, please don't forget to mark as correct.