topic Concatenate values in variable in QlikView

Concatenate values in variable

rajeshvaswani77 — Fri, 20 Jan 2012 12:40:58 GMT

Hi,

I have a variable called vErrorText

LET vErrorText ='=count({$< Server={"UKVMGAPP011"} ,Status={"ERROR"},[Log Source]={"ICC FS"},LogDate={">=' & chr(36) & '(vTodaysDate)"}>} Status)' & chr(13) & chr(10);

SET vErrorText = $(vErrorText) & ' - xyz';

If I comment out the SET statement, it prints me the exact output of the set statement.

Next I want to concatenate - xyz to the set expression output.

Could someone help on this?

However this does not work. I am doing Somthing wrong here.

thanks,

Rajesh Vaswani

Concatenate values in variable

jagannalla — Fri, 20 Jan 2012 12:50:09 GMT

Where you are displaying the content of vErrorText?

If you are displaying in text object just give = $(vErrorText) & ' - xyz'

Concatenate values in variable

rajeshvaswani77 — Fri, 20 Jan 2012 12:55:11 GMT

I have lot of such expressions and have to keep joining them, finally would be declared as a variable for an alert to be emailed.

thanks,

Rajesh Vaswani

Concatenate values in variable

swuehl — Fri, 20 Jan 2012 13:05:53 GMT

Not sure if I understand what you want to achieve, but try using a LET statement in your second line to actually evaluate the concatenation.

Re: Concatenate values in variable

jagannalla — Fri, 20 Jan 2012 13:09:26 GMT

can you explain little bit more... What is the input and what is your output with example.

It is not clear for us...

Concatenate values in variable

rajeshvaswani77 — Fri, 20 Jan 2012 13:32:38 GMT

Hi Jagan,

I wan to declare a heading

h1 h2 h3 h4

this will be assigned to one variable.

next the body will be hardcoded

v1 v2 v3

then set analysis expression e1 evaluated

Finally the variable has to contain text

h1 h2 h3 h4

v1 v2 v3 e1

thanks,

Rajesh Vaswani