Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

Maps and number formatting


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

1 Solution

Accepted Solutions
Employee
Employee

Re: Maps and number formatting

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')

2 Replies
Employee
Employee

Re: Maps and number formatting

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
Contributor II

Re: Maps and number formatting

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