Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
tnunes
Partner - Contributor II
Partner - Contributor II

Not so easy filter with some conditions

Hi, 

I will try to explain my problem using an example, please fill free to ask more.

I need to count distinct users (represented as U) and I am able to do that if I select T1Col1.

tnunes_0-1684968293380.png

tnunes_1-1684968459911.png

Considering these 2 tables , the issues is when selected T2Col2 or T2Col3, I am filtered by my selection, but what I need is, when select one of these Col, it should ignore the selection for count, and need to look for T1Col1 associated values. 

tnunes_2-1684968646500.png

In this map, you can see what I need.

Grouping by T1Col3, count distinct T2Col1.

All groups have 5 distinct users

S1 group have 4 distinct users

S2 group have 1 distinct users

S3 group have 2 distinct users

Shared distinct users value is 1

 

Other option is, when I filter by T2Col2 or T2Col3, if it's possible to select automaticaly the associated values in T1Col1, it can solve almost all the issue. Is it possible? 

Thanks 

 

 

Labels (1)
1 Reply
Sabrina_V
Partner - Creator II
Partner - Creator II

To ignore a selection you need to write a set analysis like this {<Field1ToIgnore=,Field2ToIgnore=>}