Use Aggr only on dim

[Louveduval]

Hello, 

I try to use aggr(only( 
but I miss something 

I would like to remouve  Autre 

=aggr(only({<[FamilleStat]={"PAC","CHAUDIERES","BIOMASSE"}>}),FamilleStat)


Can you help me ?

Best regard 

[sbaro_bd]

Hello @Louveduval ,

If your aim is to exclude one value from a dimension, you can simply use an IF function combined with qlik objects options : 

- Use a calculated dimension like this:

IF(FamilleStat = 'Autres', null(), FamilleStat)

- Disable the option "Include Nul values"

Regards.

[Sohan_Patil · Accepted solution]

Hi,

You can try this expression:

 =aggr(only({<FamilleStat -= {'Autres'}>}FamilleStat),FamilleStat)

[Louveduval]

Sadly , It doesn't work