Text to a numeric Value

[#1]

Hello, I was wondering if someone could help me. I am still new to Qlikview and cannot figure something out. In my Below expression I have a text box that shows a number something like this.

Population:

1000000

I would like it to add the commas like a number. I cant seem to get it work in a text box.

Population:

1,000,000

=' Population:' & chr(10) & count (Distinct Client_ID)

Thanks,

Freddie

[sunny_talwar · Accepted solution]

Try this:

=' Population:' & chr(10) & Num(Count (Distinct Client_ID), '#,##0')

[#3]

Awesome thanks. Dang I was so close. I forgot to add the '.