Maps and number formatting

[joeybird]

Hiya

Qlik Sense

I am using a map to show data of number of customers on a geo map.

this uses a count (customer) function.

it works however...is there a way of formatting the number to simple?

its showing up example as 150.75k

please help

Kind Regards

joeybird

[JonnyPoole · Accepted solution]

Could you create a Master Item / Measure first ?

... and in the measure definition use the num() function to format as money / integer etc... ?

ex:  num(sum(Sales) * count(OrderID),'#,##0')

[joeybird]

Hiya

Thank you xx

done, but no need for the master item

amended your code and it worked

num(count(Customer),'#,##0')

Kind Regards

Joeybird x