Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
Creator III

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
mark6505
Partner - Specialist III
Partner - Specialist III

Hi

Try

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

Mark

View solution in original post

4 Replies
antoniotiman
Master III
Master III

Try this

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

aronwilliamson
Creator
Creator

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

mark6505
Partner - Specialist III
Partner - Specialist III

Hi

Try

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

Mark

greend21
Creator III
Creator III
Author

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