topic Re: Maps and number formatting in App Development

Maps and number formatting

joeybird — Mon, 27 Apr 2015 10:36:46 GMT

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 — Mon, 27 Apr 2015 12:51:19 GMT

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 — Mon, 27 Apr 2015 13:06:38 GMT

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