Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

rajeshvaswani77
Valued Contributor III

Concatenate values in variable

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

5 Replies
Partner
Partner

Concatenate values in variable

Where you are displaying the content of vErrorText?

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

rajeshvaswani77
Valued Contributor III

Concatenate values in variable

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

MVP
MVP

Concatenate values in variable

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.

Partner
Partner

Re: Concatenate values in variable

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

It is not clear for us...

rajeshvaswani77
Valued Contributor III

Concatenate values in variable

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

e1

Finally the variable has to contain text

h1  h2  h3  h4

v1  v2   v3   e1

thanks,

Rajesh Vaswani