Color expression for multiple colors is not working in Word cloud extension.

[Prabhu]

Hi All,

I am using the  below expression in Word cloud extension. It is picking only the first color. It is not working for remaining two colors.

=if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') <'70%', RGB(232,9,9),


if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') >='70%' and


num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') <='89%', RGB(250,166,53),


if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') >='90%', RGB(84,130,53))))

Please help me.

[Anil_Babu_Samineni · Accepted solution]

May be try this?

=if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') <0.7,RGB(232,9,9),
if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') >=0.7 and
num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') <=0.89,RGB(250,166,53),
if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00%') >=0.9,RGB(84,130,53))))

[pradosh_thakur]

May be this

if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00') <0.7,RGB(232,9,9),


if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00') >= 0.7and


num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00') <=0.89,RGB(250,166,53),


if(num(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT),'##.00') >= 0.90,RGB(84,130,53))))

[Prabhu]

Hi Ravi,

I have tried this. But, no luck.

[Prabhu]

Hi Pradosh,

I have tried this. But, still not working.

[Anil_Babu_Samineni]

Could be wrong with your expression. And expression should match with the condition

[Prabhu]

The same expression is working for other charts. I am using QV 12. Word cloud extension  supports QV 11 only?

[Anil_Babu_Samineni]

Can you share sample to test?

[johnca]

Another possibility...remove the number formatting entirely and just use the values:

=if(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT) <0.7,RGB(232,9,9),
if(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT) >=0.7 and
sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT) <=0.89,RGB(250,166,53),
if(sum(LA_DQM_QC_DETAIL_FACT.QC_COUNT)/sum(total LA_DQM_QC_DETAIL_FACT.QC_COUNT) >=0.9,RGB(84,130,53))))

[Prabhu]

Thanks, it is working. Only problem is it is hiding some components with bigger size. If we adjust the size then no problem.