Filter pane hide values

[nvijay5757]

Hi,

in Filter pane to hide the values.

Actual values are : India,UK,USA,NZ      to hide NZ value.

i am using this expression:   

=Aggr(Only({<Evaluation={'India','UK','USA',}>}Evaluation),Evaluation)

working fine. but without mention the values like India,UK,USA to hide only NZ value.

help me thanks.

[MayilVahanan]

Hi 

Try like below

=Aggr(Only({<Evaluation-={'NZ'}>}Evaluation),Evaluation)

[sidhiq91]

@nvijay5757  You can try the below code:

=Aggr(Only({<Evaluation-={'NZ'}>}Evaluation),Evaluation)

[nvijay5757]

Hi,

Thanks for your reply.

when i select filter value showing only one value.

[MayilVahanan · Accepted solution]

Hi

Try like below

=Aggr(Only({<Evaluation={"*"}-{'NZ'}>}Evaluation),Evaluation)
or
=Aggr(Only({<Evaluation=-{'NZ'}>}Evaluation),Evaluation)

Both are same

[SunilChauhan · Accepted solution]

is that aggr realy required.Create a New Field like below and use in filterpane

Load if(Country<>'NZ',Country) as CountryNew,
Country;
Load * inline [
Country
India
UK
USA
NZ
];