Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rt_new_user
Contributor III
Contributor III

If or Case expression for a dimension

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. 

Country Name condition.jpg

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps this?
Sum({<[Carrier name]=P([Carrier name]), roamers_distribution={"=Sum(unique_roamer)>=2000"}>}roamers_distribution)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

Perhaps this?
Sum({<[Carrier name]=P([Carrier name]), roamers_distribution={"=Sum(unique_roamer)>=2000"}>}roamers_distribution)
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
rt_new_user
Contributor III
Contributor III
Author

Thanks for your response.

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

Doing so doesn't really make any difference 😞