topic Re: Text to a numeric Value in QlikView

Text to a numeric Value

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Text to a numeric Value

sunny_talwar — Mon, 23 Jan 2017 18:26:07 GMT

Try this:

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

Re: Text to a numeric Value

Mon, 23 Jan 2017 18:31:02 GMT

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