Concatenate

[#1]

Dears

I would like to concatenate one expression with a text.

The expression is "=count([Claim #])" and I would like to write after the value resulted from this expression the word "Claims".

So, the text box will show me for example: 563 claims

How can I do it?

Can you help me please?

[erichshiino]

=count([Claim #]) & ' claims'

[#3]

Thanks Erich,

It was so simple!
I would appreciate if you could help me in another topic about the difference between two dates.

Have a nice day

Bye

[marsmike]

Erich, since you were so fast with that first answer......

I'm new to QlikView, btw, but I am trying to do the concatenation in the opposite order - I want the text first, then followed by the expression, like this  --- Claims & =count([Claim #]).

I'm using this in a chart title in v8.5.

[erichshiino]

Hi, MIke:

for you it must be like this:

= 'Claims '& count([Claim #])

[marsmike]

Your reputation continues!  I can't believe how many different things I tried but NOT moving the " = " to the front.  Thanks!