QlikView App Dev

[rt_new_user]

Hi All

Can someone please help me with an expression i need to use in my Chart? I have Country Name in my Dimension. But if i don't use any condition it spits out all the countries on the chart, however what i want is to only show the countries when a certain condition is met. 

So the condition is That display only those country names when:

1. Sum of Unique_Roamers >=2000

and 

2. Display for only that Carrier Name which has the highest 'roamers_distribution'

There is another field which i will be showing on my graph as an expression which is Success rate.

Hope it makes sense.

Regards

RT

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?
Sum({<[Carrier name]=P([Carrier name]), roamers_distribution={"=Sum(unique_roamer)>=2000"}>}roamers_distribution)

[rt_new_user]

Thanks for your response.

Should i put this statement in "Enable conditional dimension"?

Doing so doesn't really make any difference 😞