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: 
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"