dimensions with condition

[adiarnon]

hi,

i have a straight table with two dimensions.

i want that the table will show only two values of one of the dimensions.

lets say-

my dimension 'country'

the values i want to show 'USA' 'israel'

i tried to put  in the enable condition: if(country='USA' or country='israel',1,0)

its not working.

can someone help me?!

[#2]

Hi,

Try this  if(country='USA' and country='israel',1,0)

Thank you

Vardhan

[iktrayanov · Accepted solution]

Use calculated dimension. something like this

If(match(country,'USA','Israel') > 0,country)

Keep in mind that match is case sensitive.

[Carlos_Reyes]

Why don't you use Set Analysis in your expressions?

Place Country as your Dimension and restrict the Country values using Set Analysis.

Try:

Sum ( {$< Country= {'USA', 'israel'}>}  ValueField)

[luis_pimentel]

A calculated dimension like: If(match(country,'USA','Israel') > 0,country) is the solution you are looking for.

[luis_pimentel]

Using just Set Analysis in the expressions, the other values will be listed anyway.

[Carlos_Reyes]

Nope if you only have that expression... If you have more than one expression you only have to place the Set Analysis filters in all the other expressions... It's a different approach.

EDIT... Review the attached file.

[Peter_Cammaert]

and "Suppress When Value is NULL" checked on the Dimension tab. Otherwise you may get three rows.

Peter

[#9]

Hi Adi,

Two things:

• Use the following as calculated dimension : =if(match(Country,'USA','Iran'),Country)
• Check the 'Suppress when value is Null' option

Attached is an example

Thanks

AJ

[#10]

This is informative. Thanks for sharing it. Didn't know about this.