Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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 (4)
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)

)