Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
=count([Claim #]) & ' claims'
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
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.
Hi, MIke:
for you it must be like this:
= 'Claims '& count([Claim #])
Your reputation continues! I can't believe how many different things I tried but NOT moving the " = " to the front. Thanks!