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: 
Qlikuser09
Creator II
Creator II

Butterfly chart , formatting symbols

NUM(COUNT({<Sex = {'F'}>}[ID])*-1,'#,###;#,###')

or

NUM(COUNT({<Sex = {'F'}>}[ID])*-1,'#,##0;#,##0'), not helping with taking off the negative symbol from my butterfly bar chart, is there any other work around

3 Replies
brunobertels
Master
Master

try : 

NUM(sum(COUNT({<Sex = {'F'}>}[ID]))*-1,'#,##0;#,##0')

Or
MVP
MVP

I can confirm that num(NumberField, #,##0;#,##0) works correctly in Qlik Sense bar charts, both insofar as the axis format and the tooltip format.

Or_0-1635266097488.png

 

Qlikuser09
Creator II
Creator II
Author

NUM(sum(COUNT({<Sex = {'F'}>}[ID]))*-1,'#,##0;#,##0'), this say "nested aggregation not allowed"