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