topic Re: Dimension without aggregation in QlikView

Dimension without aggregation

capriconuser — Wed, 15 May 2019 08:28:58 GMT

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"

tresB — Wed, 15 May 2019 08:36:51 GMT

Try like below as calculated dimension:

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

and then check 'Suppress When Value is Null' box

capriconuser — Thu, 16 May 2019 04:49:14 GMT

i dont want to use if condition

Anil_Babu_Samineni — Thu, 16 May 2019 04:51:24 GMT

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]