Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
greend21
Contributor II

Number Formatting of Dimensions

Hi,

I have a dimention that is currently showing numbers such as 388130 but I want this to display as 388,130. I tried using

Num(FieldName,'##,###') but it isn't working. Could you let me know what I am doing wrong?

Thanks,

Dan

1 Solution

Accepted Solutions
Partner
Partner

Re: Number Formatting of Dimensions

Hi

Try

NUM(FieldName,'#,##0')

Mark

4 Replies
antoniotiman
Honored Contributor III

Re: Number Formatting of Dimensions

Try this

Num(FieldName/1000,'0,000')

aronwilliamson
Contributor

Re: Number Formatting of Dimensions

Format the number using the "Number" Tab in properties of the sheet object (Chart, Table, List etc.)

Partner
Partner

Re: Number Formatting of Dimensions

Hi

Try

NUM(FieldName,'#,##0')

Mark

greend21
Contributor II

Re: Number Formatting of Dimensions

Only expressions show in that tab. This is a dimension.