Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try :
NUM(sum(COUNT({<Sex = {'F'}>}[ID]))*-1,'#,##0;#,##0')
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.
NUM(sum(COUNT({<Sex = {'F'}>}[ID]))*-1,'#,##0;#,##0'), this say "nested aggregation not allowed"