Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)')