Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

moslem_teymoori
Contributor

showing two different field in the same field,

Capture.JPG
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

1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: showing two different field in the same field,

because you're using 2 measures here.

instead, use 1 measure and put this on it:

='LAST UPDATE '&Min(LastUpdate)

4 Replies
YoussefBelloum
Esteemed Contributor

Re: showing two different field in the same field,

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...

moslem_teymoori
Contributor

Re: showing two different field in the same field,

Capture.JPG
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 :
Capture1.JPG

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
Esteemed Contributor

Re: showing two different field in the same field,

because you're using 2 measures here.

instead, use 1 measure and put this on it:

='LAST UPDATE '&Min(LastUpdate)

OmarBenSalem
Esteemed Contributor

Re: showing two different field in the same field,

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)

Community Browser