topic Re: hide the Filter field if value is not there in App Development

hide the Filter field if value is not there

nima94 — Thu, 27 Aug 2020 07:14:46 GMT

i have filter of group of Customers

if i select a range of date, some of Customer filter color changes to gray which means there is no value of selected date for those Customer Group.

now instead of being gray, i want to those filter be disappierd those Gray Group.

tresB — Thu, 27 Aug 2020 07:25:37 GMT

You can use expression instead of using direct field.

Aggr( [Customer Group], [Customer Group])

nima94 — Thu, 27 Aug 2020 12:17:31 GMT

thanks it works.

but im using the belloew :

=if(IsNull(Customer Group),'NA',Customer Group)

can you may guide me how i can combine both of them ?

tresB — Thu, 27 Aug 2020 12:44:56 GMT

Aggr(

if(IsNull([Customer Group]),'NA',[Customer Group])

, [Customer Group]

)

nima94 — Sat, 29 Aug 2020 07:27:32 GMT

Thanks