Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

raZor
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)

2 Replies
Claudiu_Anghelescu
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.
Claudiu_Anghelescu
Valued Contributor

Re: Colors in pie chart

This solution helped you? 

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