topic Concatenate in QlikView

Concatenate

Mon, 18 Apr 2011 21:00:41 GMT

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?

Concatenate

erichshiino — Mon, 18 Apr 2011 21:03:33 GMT

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

Concatenate

Mon, 18 Apr 2011 21:10:22 GMT

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

Concatenate

marsmike — Thu, 19 May 2011 13:47:29 GMT

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.

Concatenate

erichshiino — Thu, 19 May 2011 13:53:43 GMT

Hi, MIke:

for you it must be like this:

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

Concatenate

marsmike — Thu, 19 May 2011 14:11:05 GMT

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