showing two different field in the same field,

[Anonymous]

Hello everybody,

i would like to merge this two label not by master method, but in scripting , these two fields are deferent variable taken from SQL code,
any hint for scripting ) imagine the name of the variable or fields are LU for last update  and Tim for the time

Thanks

[YoussefBelloum]

Hi,

I'm not sure I understand your need, but you can concatenate fields in one field on the script.

example

table:

load

.

.

FieldA&FieldB&FieldC as Derived_field.

from...

[Anonymous]

Thanks
but how can i concatinate in the right pannel in scripting ? if i add another measure beside the last update it will become like this :

i want both to be the sane size and on the same line, i think it is some scripting trick to add both on the same label ,

[YoussefBelloum · Accepted solution]

because you're using 2 measures here.

instead, use 1 measure and put this on it:

='LAST UPDATE '&Min(LastUpdate)

[OmarBenSalem]

u don't have to do it in the script;

in ur KPI object (the second one)

instead of calling directly the variable time : $(time)

add the Last Update string:

='Last Update : '&$(time)