Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
capriconuser
New Contributor III

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
Highlighted
MVP
MVP

Re: Dimension without aggregation

Try like below as calculated dimension:

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

and then check 'Suppress When Value is Null' box
Highlighted
capriconuser
New Contributor III

Re: Dimension without aggregation

i dont want to use if condition 

Highlighted

Re: Dimension without aggregation

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]

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)