Currently, this is the function I am using for the dimension definition. With this I am able to select a specific value in "Supplier_Name". Lets say I chose Qlik. And the other table shows me all rows where the "Description" has a first part of the string in the description. Perhaps not the best solution but I think I have at least moved somewhere.
What I would want
IF(lower(ReconciliationDescription) LIKE '*'&SubField(lower($(vCurrentSelection)), ' ',1)&'*',ReconciliationDescription)
(variable vCurrentSelection is defined as GetFieldSelections(SUPPLIER_NAME)
Currently it looks as following. Table 1 on the left, table 2 on the right, depending on what I choose in table 1, the output changes in table 2.
What I would want to achieve though is to base this on the unique selection. Though based on same advanced if rules. If I select for example the first row AYDIN of the table 1. It would lets say only show me rows that are +-7days difference from the date specified in table 1 (table 2 also has date values as you can see).