Assign dynamic labels to chart using data from another unrelated table.

[saurabh_Qlik1]

I have a table with the following data:

ID	Label1	Label2	Label3	OpsDate
ComA	96%	93%	91%	2023-05-31
ComB	95%	99%	92%	2023-05-31
ComC	98%	95%	99%	2023-05-31
ComA	76%	73%	71%	2023-04-30
ComB	75%	79%	72%	2023-04-30
ComC	78%	75%	79%	2023-04-30

Using the following code I created a line chart that shows the values for any one ID and one OpsDate at a time by using filters:

if(valuelist('Label1','Label2','Label3') = 'Label1',[Label1],
if(valuelist('Label1','Label2','Label3') = 'Label2',[Label2],
if(valuelist('Label1','Label2','Label3') = 'Label3',[Label3])))

It gives me the following output:

I have another table (unrelated to the data table) which contains the labels for each of these data points for each of the Ops date:

2023-04-30	2023-05-31
A	X
B	Y
C	X

I want to be able to pick up the values from this table for the selected OpsDate in the filter and apply them as 'labels' in my chart shown above.

So for the OpsDate of 5-31-2023, the labels in the chart should show as 'X', 'Y' and 'Z' for the three data points.

Please help!

Excel data files attached.