Need help with Expression.

[#1]

My requirement is to fade the color of Bars in a Bar-Chart gradually. Each bar represent a represent revenue by country. We have only 10 bars (as we select only top 10 countries by revenue, so I used RANK).

I am using the expression in "Background-Color" of the chart as:

if(aggr(rank(sum({<[Country Name]-={"Wor*","OECD*","South*","High*","*Sahara*","Low*","Latin*","Heavily*","Least*","Fragile*","European*","East *","Euro*","Arab*", "*iddle*","North A*"

}>}Population)),[Country Name])<=1,RGB(33,52,73))

In the above expression we are excluding certain countries.

I have to write this expression again and again in "if-else" format means if Rank<2 then "Color Code-2"...if Rank ❤️ then "Color-Code-3",

So is there a way where I can use the entire RANK operation inside a variable and use that variable instead?

[PrashantSangle]

Hi,

try with pick()

See in help menu for detail.

Regards

[PrashantSangle · Accepted solution]

Hi,

like

Pick(YourExpression,RGB(assign_rgb_value_for_1_rank),RGB(assign_rgb_value_for_2_rank),RGB(assign_rgb_value_for_3_rank), and so on)

Regards

[#4]

That worked like a charm!!! Thank you so much!