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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
xxxx2
Contributor II
Contributor II

Use a table to filter but keep all lines in the table

Hello,

 

I have a table with two dimensions and a calculated expression, and I would like to use this table to filter data on other graphs. 

I would like this table to keep all lines when filtering. Is it possible ?

 

This is what my table look like :

xxxx2_1-1741014844451.png

 

But when I select something :

xxxx2_2-1741014862715.png

I would like other graphs to be filtered but this table to stay the same as when no "Client" and no "Recap" are selected (just those 2, I have other selected fields that I want to keep).

 

Dimensions :

- Client

- =if(Recap = 'LAY' or Recap = 'ENF'
, Recap
)

 

Expression :

= Aggr(
sum( IF(
 
IF(((Sais / Sais_Soc) -1) < £Ecart_Sais, 1, 0)
+
IF(((An / An_Soc) -1) > £Ecart_An, 1, 0)
+
IF(((QtFin / Cons) -1) > £Ecart_Cons, 1, 0)
= 3
, 1
, 0
)
)
, Client, Recap
)
 
 
 
Thanks for your help
 
Labels (1)
10 Replies
xxxx2
Contributor II
Contributor II
Author

Ok thank you very much for your help !

 

Have a good day !