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

[Gysbert_Wassenaar]

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

[#3]

Worked fine, didn't know that combination. Thanks!

[#4]

I thought I understood it but I actually didn't...

What if I want to use this new value in a set expression?

My try:

=if(maxstring(<{KPI_Name={"$(=subfield(concat({<KPI_Category_Name={"$(=SubField(concat(KPI_Category_Name,';'),';',1))"}>} KPI_Name, ';'),';',1))"}}> Statusname)='green','qmem://<bundled>/BuiltIn/led_g.png','')

Thank you very much!

[#5]

Hi everyone,

this is my KPI-Name (which totally works in a textbox) :

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

I now want to get the Status in this KPI-Name so I need to use it in another Set-Expression which I am not able to create

This has to look like

=maxstring(<{KPI_Name="{$(=subfield(concat({<KPI_Category_Name={"$(=SubField(concat(DISTINCT KPI_Category_Name,';'),';',4))"}>} KPI_Name, ';'),';',1))}"}> Statusname)

... or anything like that but I don't know.

Thanks for any kind of support!

Regards

[#6]

Doesn't work

[#7]

HI ,

  Try this below code  small change to your expression .

=maxstring(<{KPI_Name={"$(=subField(concat({<KPI_Category_Name={"$(=SubField(concat(DISTINCT KPI_Category_Name,';'),';',4))"}>} KPI_Name, ';'),';',1))}"}> Statusname)

Regards

Yusuf

[#8]

hm, this doesn't work and gives the KPI_Name but I need the Statuscolor (like shown before)

thank you for trying.

still got no solution

[#9]

It says expression OK but doesn't show anything...

[#10]

Perhaps for that Filter no data is shown .

Can you try using some other value for the Filter(Fields)  in the Expression .

Regards

Yusuf