topic Re: If or Case expression for a dimension in QlikView

If or Case expression for a dimension

rt_new_user — Wed, 27 Feb 2019 01:10:50 GMT

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

Re: If or Case expression for a dimension

Anil_Babu_Samineni — Wed, 27 Feb 2019 02:12:04 GMT

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

Re: If or Case expression for a dimension

rt_new_user — Wed, 27 Feb 2019 02:21:14 GMT

Thanks for your response.

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

Doing so doesn't really make any difference 😞