Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
)