Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gump123
Contributor
Contributor

converting whole number into thousend

I have revenue in KPI 

sum({<isavi= {'Y'}>}[Total Revenue])

which get me    $4526116615.55

no i want that number to be shown as 452.6K . 

 

I tried auto format but not working.

1 Reply
Or
MVP
MVP

452.6K is 452600, assuming standard numeric abbreviations (K = 1000). Your number is 4,526,116,615, which is several orders of magnitude larger.