topic Re: How to show matching values from other fields based on current selection? in QlikView

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

mrichman — Wed, 25 Nov 2020 16:16:04 GMT

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

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

sunny_talwar — Tue, 15 May 2018 12:43:47 GMT

May be using set analysis in your expression

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

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

mrichman — Tue, 15 May 2018 13:21:27 GMT

Dear Sunny,

Thank you for your prompt reply. It is working!