Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Dimension without aggregation

Hey i have a dimension countryname and from that i want only UAE country so for this i add dimension countryname

 

I tried this and from this i want to only extract UAE country 

 

 

 

```

only([Countr_Name]={'UAE'})

```

 

But this shows an error "Error in expression"

3 Replies
tresesco
MVP
MVP

Try like below as calculated dimension:

If([Countr_Name]='UAE', [Countr_Name])

and then check 'Suppress When Value is Null' box
capriconuser
Creator
Creator
Author

i dont want to use if condition 

Anil_Babu_Samineni

Use same condition in script and generate field using below condition and call that field as dimension.

If([Countr_Name]='UAE', [Countr_Name]) as [UAE Countr_Name]

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