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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Balujyothi4
Contributor
Contributor

Print Total sales in KPI

Hi 

How to print total sales in KPI as $42,234,456.

Here I need $ symbol also

Labels (1)
1 Reply
Vegar
MVP
MVP

If this should be your default money representation then you can adjust (or add) the moneyFormat variable in your application. Maybe like this:

Set MoneyFormat='$ #,##0.00; ($ #,##0.00)';

Then just wrap your measure with a money format like this: money(<Your KPI expression>).

If you do not want to edit the MoneyFormat variable then you need to set the format manually like this. 

money(<Your KPI expression>,'$ #,##0.00; ($ #,##0.00)')