Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Hamdi_G
Contributor III
Contributor III

Filter data using E() function

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,

Hamdi_G_0-1615994720990.png

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

 

Hamdi_G_1-1615994755433.pngHamdi_G_2-1615994770895.png

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

Labels (7)
1 Reply
jwjackso
Specialist III
Specialist III

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)

)