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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NickHoff
Specialist
Specialist

Formatting the Y-Axis in a line chart with $

I have the following expression:

NUM((SUM({1<Facility =  $::Facility,GroupName = $::GroupName, MarketName = $:: MarketName, DivisionName = $::DivisionName, ProcGroupDesc = $:: ProcGroupDesc, ProcedureSurgeonName=$::ProcedureSurgeonName, CalendarYear = $:: CalendarYear, CalendarMonthYear = $:: CalendarMonthYear, CalendarMonth = $:: CalendarMonth>} SupplyChainTotalCost)/COUNT({1<Facility =  $::Facility,GroupName = $::GroupName, MarketName = $:: MarketName, DivisionName = $::DivisionName, ProcGroupDesc = $:: ProcGroupDesc, ProcedureSurgeonName=$::ProcedureSurgeonName, CalendarYear = $:: CalendarYear, CalendarMonthYear = $:: CalendarMonthYear, CalendarMonth = $:: CalendarMonth>}DISTINCT SurgicalCaseSk))-$(eCostBenchmark),'$#,##0')

Which on the line points displays correctly as a $ amount.  Under the number tab my field is formatted as Money without the .00 such as  $#,##0

However, when viewing the line chart the Y Axis displays the value of the field as an integer.  How can I make my Y Axis display the money format instead of the integer?

0 Replies