Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
noemibuscemi01
Partner
Partner

Filter object filtered in a sheet not in the other

Hi,

I have two sheets (dealer and agents), when I filter a filter object in dealer I don't want the selection to affect the agent sheet. How can I do that?

 

I want that

= if (network = 'captive', exclude from the selection the ID values being part of the captive network, else show the ID field related to the network).

 

1 Solution

Accepted Solutions
noemibuscemi01
Partner
Partner
Author

I've found a solution on my own:

aggr(only({$<[MR.Network] <> {'Network Captive'}>}[MR.ID]),[MR.ID])

View solution in original post

1 Reply
noemibuscemi01
Partner
Partner
Author

I've found a solution on my own:

aggr(only({$<[MR.Network] <> {'Network Captive'}>}[MR.ID]),[MR.ID])

View solution in original post