Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Try like below
=Aggr(Only({<Evaluation={"*"}-{'NZ'}>}Evaluation),Evaluation)
or
=Aggr(Only({<Evaluation=-{'NZ'}>}Evaluation),Evaluation)
Both are same
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
];
Hi
Try like below
=Aggr(Only({<Evaluation-={'NZ'}>}Evaluation),Evaluation)
@nvijay5757 You can try the below code:
=Aggr(Only({<Evaluation-={'NZ'}>}Evaluation),Evaluation)
Hi,
Thanks for your reply.
when i select filter value showing only one value.
Hi
Try like below
=Aggr(Only({<Evaluation={"*"}-{'NZ'}>}Evaluation),Evaluation)
or
=Aggr(Only({<Evaluation=-{'NZ'}>}Evaluation),Evaluation)
Both are same
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
];