formatting large numbers in Qlik sense

[VamsiBhagavathula1]

Hi ,

I am new Qlik sense. I have a large amount generated with the aggregation of sales. I want to express these numbers in Trillions,Billions(B) ,Millions(M), Thousands(K) with in the number display. How can we achieve it ??

example : 98989987029989768.95

i want to express it as 89T,987B,029M,989K,768.95

i am looking for a custom expression format to handle this kind of large numbers which also fits for small numbers depending on the value in the cell

Best Regards,

Vamsi

[Mark_Little]

You would need to wrap it in an if statement base on the length. once you have it working you could add as a custom function for reusability. 

[udit_k]

Follow below link for row level formatting in table

Row Level Formatting in Qlik Sense - Qlik Community - 1835627

[VamsiBhagavathula1]

any example??