How to show matching values from other fields based on current selection?

[mrichman]

Hi Community,

Im currently having an issue in selecting showing matching values on other fields based on current selections. For the underlying example, I would like to filter Jack in field Name1 then field Name should show all rows where Jack is also known. It would be very nice if it can be applied vice versa.

Qlikview example:

'Blank':

Load* Inline [

Name| Name1

Jack | Jack

Jack | Paul

Mark | Paul

Jack | Patrick

Jack | Rick

Steven | Rick

Steven | Jack

] (delimiter is '|');

Ideal result: Select Jack in Field Name1 result:

Name| Name1

Jack | Jack

Jack | Paul

Jack | Patrick

Jack | Rick

Thanks in advance

[sunny_talwar · Accepted solution]

May be using set analysis in your expression

Sum({<Name = P(Name1), Name1>}Measure)

[mrichman]

Dear Sunny,

Thank you for your prompt reply. It is working!