Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

Show matching value in Table

Hello Folks,

I have a data model with a Table.  In my data model, I have Record Numbers for two different sets of records.  What I would like to do, is show a column whereby if the record number of Instance 1 in RecordSet 1 matches another Instance in RecordSet 2, then that record number is shown.  Here is a screenshot of what I'm trying to do.

Capture23.PNG

As we can see, in the srp_number column, we have matching dra_filenumbers.  I would like to show these on the same row.  My thought process led me to something like this which doesn't work.

IF( (Total dra_filenumber ) = srp_number, dra_filenumber )

I'm trying to say "Ignore selections and data linkage, check over all the srp_numbers, and if they match the dra_filenumber, then put that value in the column".

1 Reply
mjtaft2017
Partner - Creator
Partner - Creator

Are these fields (srp_number and dra_filenumber) both on the same table in your source data?  Can you upload a sample?