Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))))
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))))
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))))
Hi Ravi,
I have tried this. But, no luck.
Hi Pradosh,
I have tried this. But, still not working.
Could be wrong with your expression. And expression should match with the condition
The same expression is working for other charts. I am using QV 12. Word cloud extension supports QV 11 only?
Can you share sample to test?
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))))
Thanks, it is working. Only problem is it is hiding some components with bigger size. If we adjust the size then no problem.