Show lines in a table only if - SET ANALYSIS

[chapil]

Hello, 

I would love to know the best way to do a filter in an table object Qlik Sense

I want to show lines only if - for example 

Age | Name | Adress | Country

Only lines for FR Country without using an if condition - must use a Set analysis 

Thanks a lot !

[MayilVahanan]

Hi

Try like below

Dim: Age , Name , Adress

Exp: Only({<Country={'FR'}>}Country)

or

It depends on ur expr.

Dim:  Age , Name , Adress, Country

Exp: Sum({<Country={'FR'}>}Sales)

[chapil]

I tried with this syntax :  Only({<Country={'FR'}>}Country) in the expression space (field dimension > Country), it doesn't work like this 

INVALID DIMENSION 

Am I writing this expression in the write space ? Where do you put it ? 

Thanks for your answer ! 

[chapil]

It's working with an IF expression but I would to avoid to use it 

=if([COUNTRY]='FR', [COUNTRY], null())

if this can help u 

[MayilVahanan]

HI 

You want to mention in the expression

[chapil]

Yes, where else if not ? 

[sunny_talwar · Accepted solution]

You can try this as your dimension

Aggr(
    Only({<Country = {'FR'}>} Country)
, Country)