topic Need help with Expression. in QlikView

Need help with Expression.

Fri, 01 Jul 2016 09:51:03 GMT

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?

Re: Need help with Expression.

PrashantSangle — Fri, 01 Jul 2016 09:57:55 GMT

Hi,

try with pick()

See in help menu for detail.

Regards

Re: Need help with Expression.

PrashantSangle — Fri, 01 Jul 2016 09:59:47 GMT

Hi,

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

Re: Need help with Expression.

Fri, 01 Jul 2016 10:09:02 GMT

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