Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Text Object Number Formating

I am trying to format the following expression:

=Count(Distinct [Script Number] ) whose value is 26186 to be 26,186 and i am getting errors.  How can i accomplish this.

Thanks in advance.

1 Solution

Accepted Solutions
JonnyPoole
Former Employee
Former Employee

Does this work ? 


num( Count(Distinct [Script Number] ), '#,###')


or


num( Count(Distinct [Script Number] ), '#,##0')

View solution in original post

2 Replies
JonnyPoole
Former Employee
Former Employee

Does this work ? 


num( Count(Distinct [Script Number] ), '#,###')


or


num( Count(Distinct [Script Number] ), '#,##0')

Anonymous
Not applicable
Author

Many thanks, the trick was on the "Num"

Regards.