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: 
Not applicable

Money format in qliksense

I am trying to get the costs display in correct format in qliksense but having trouble displaying the negative numbers in the correct format in qliksense pivot. Is there a way to display the negative numbers in qliksense in brackets using a custom format?



Example:


Money#(Sum(costs '#,##0.;(#,##0.)')



2 Replies
sunny_talwar

Can you try this:

Money(Sum(costs), '#,##0;(#,##0)')

Not applicable
Author

Thank you. This works in the qliksense pivot, but I am still having issues with it when using the pivot table extension i.e. JSPivotTable.