Dynamic Text in Qlik Sense Table - like Python f-string: print(f'My text {Var1}')

[pandabear_de]

Hi

I am trying to put together signals for users based on some kind of data conditions. There will be a set of different rules, that will grow over time. Each rule has a specific explanation text for the user. To handle the data from a multiple rules, a standardized result table is defined.

The problem: How can I show the user the explanations containing the data dynamically.

Example Data (please ignore if the data makes sense or not!)

[Signal_Results]:

ID, Rule_ID, Val1, Val2
1,1,10,20
2,1,30,40
3,2,5,15

[Signal_Static]:

Rule_ID, Explanation
1, Combination A was identified at {Val1} with product {Val2}
2, Temperature Exception was set to {Val1}. Measured {Val2}

Required Output in Qlik Sense table:

ID 1 -> Combination A was identified at 10 with product 20
ID 2 -> Combination A was identified at 30 with product 40
ID 3 -> Temperature Exception was set to 5. Measured 15

In python this could be solved with a print(f”Combination A was identified at {Val1} with product {Val2}”)

How can I dynamically show the descriptions in Qlik Sense without having to output complete descriptions in my Signal_results table?

Thanks for your help!

[tm_burgers]

I think you can skip the [Signal_Static] table

in the table measure expression use the following, 

if(Rule_ID=1,'Combination A was identified at '&Val1&' with product '&Val2,
if(Rule_ID=2, 'Temperature Exception was set to '&Val1&'. Measured '&Val2,' '))

if