Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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')
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