topic Format value in a text object in QlikView

Format value in a text object

amber2000 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to format a value in a text object:

The value looks like this: 1948738 and I want it to be 1.948.738

This is what I set in the General Tab in Text:

='Amount of Cases - ' & sum(PL_Nr_Of_Cases)

Does anyone has an idea on how I can do that please?

Kind regards,

Monique

antoniotiman — Wed, 28 Sep 2016 10:17:47 GMT

Hi Monique

='Amount of Cases - ' & Num(sum(PL_Nr_Of_Cases),'#.##0')

Regards,

Antonio

Wed, 28 Sep 2016 10:29:06 GMT

Hi,

try this:

='Amount of Cases - ' & num(sum(PL_Nr_Of_Cases),'#,##0')

Thanks!

miguelbraga — Wed, 28 Sep 2016 10:36:17 GMT

Hey there,

Try this expression:

='Amount of Cases - ' & Num(1948738 ,'#.##0', ',', '.')

Best regards,

D.A. MB

amber2000 — Wed, 28 Sep 2016 11:05:10 GMT

This works perfectly, thanks guys