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: 
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=>}