Filter data using E() function

Hamdi_G — Sat, 16 Nov 2024 17:23:06 GMT

Hello,
I'm trying to filter my data using E( ) in set Expression "I want to exclude data when i select the field name in the filter Pane".

What i want :
When no filter field is selected => My return value must be the highest and the return value will decrease if I select filter My field.

My expression :

count({<ERREUR_LEV = e([LISTE_DEFAUT_LEV.ERREUR_LEV]),ID_ASCENSEUR ={1}>}ERREUR_LEV)

My result :

When no filter is applied the return value is 0,

and only when I start choosing data the value will change.

so how to make my result appear even if no filters are selected
Thanks

Re: Filter data using E() function

jwjackso — Wed, 17 Mar 2021 19:34:06 GMT

You can try using an If statement and only use the E() function when something is selected:

If(GetSelected([LISTE_DEFAUT_LEV.ERREUR_LEV]) > 0,

count({<ERREUR_LEV=e([LISTE_DEFAUT_LEV.ERREUR_LEV),ID_ASCENSEUR={1}>}ERREUR_LEV),

count({<ID_ASCENSEUR={1}>}ERREUR_LEV)

)

topic Filter data using E() function in App Development

Filter data using E() function

Re: Filter data using E() function