Students :
| id | Student Name |
|---|
| 1 | Prady |
| 2 | Brown |
Members :
| id | Member Name |
|---|
| 1 | Karen |
| 2 | Brown |
| 3 | Prady |
Those are the two tables in my application.
I am out of ideas on how to filter Members table using the selection on the Students table's Student Name field.
Note: I dont want to keep the column names as I have other complexities.
Do I have to use set analysis for this?
How to let Qlik Sense know that Student Name and Member Name are same but with different names?
