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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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 !