Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using set analysis in your expression
Sum({<Name = P(Name1), Name1>}Measure)
May be using set analysis in your expression
Sum({<Name = P(Name1), Name1>}Measure)
Dear Sunny,
Thank you for your prompt reply. It is working!