topic Concat text in expression in QlikView

Concat text in expression

Mon, 31 Mar 2014 20:13:15 GMT

Hello, I'd like to have the title of a table with a text and an expression like that :

"Number of records :" + Count([field])

How can I do that?

Thanks

its_anandrjs — Mon, 31 Mar 2014 20:16:49 GMT

Go like this way

='Number of records :' &Count([field])

Hope this helps

maxgro — Mon, 31 Mar 2014 20:27:15 GMT

='Number of records : ' & num(count(field), '#,##0')

Mon, 31 Mar 2014 20:32:23 GMT

I Thank everyone for the reply.

its_anandrjs — Mon, 31 Mar 2014 20:49:22 GMT

If you got correct answer from thread so mark it correct so other can refer this.

Thanks & Regards