Qliksense KPI number Format

[davyqliks]

Hi There,

Is it possible to show the following as 17k in the KPI box?

tried obvious number formatting but no joy. Any help would be great, thanks so much

DavyQliks

[Vegar · Accepted solution]

You could do like this to force k-presentation

NUM( Sum(Qty)/1000, '0k')

[PradeepK · Accepted solution]

Not sure if you should do this type of data formatting.. 

Also think about case like : 16.12K -> should this be considered as 16K .. or Still 17K ?

For 1000 multiples .. Reference Purpose Only

Round(Num(<Measure>/1000))*1000

 You can build on the same logic to handle different multiple cases

[davyqliks]

thanks for the replies,

Thats great, worked perfectly thanks

[PradeepK]

MMM.. not sure about this. 🤔

Don't you think this will just show 0 if sum(Qty) returns 100 multiples or low .. example 444.