Using functions in set expression

[#1]

Hi all,

I want to use this formula in a textbox, but it does not show any data. Do you have got an idea?

=concat({<KPI_Category_Name=$(=SubField(concat(KPI_Category_Name,';'),';',1))>} KPI_Name, ',')

I tried the inner formula

=SubField(concat(KPI_Category_Name,';'),';',1)

in a textbox and it gives me the right value.

Thanks for any kind of help!

Regards

[#2]

I have created a table which shows that there is data for this field so there has to be a value..

[#3]

I think this doesn't work like this so I just created an example app.

The red one has to show the statusname of Cat1 - KPI1 , flexible without writing 'Cat1' or 'KPI1' into formula.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#5]

It's great! Thank you very much!