# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for
Did you mean:
Partner

## Display negative numbers as positive

I have a population chart. Men's values are displayed to the right and women's values to the left, with the following measures:

For men: num(sum({\$<Kjønnskode={'1'},År={\$(=\$(vMidyear))}>} [Folkemengde_3112]),'#.##0;#.##0')

For women: num(sum({\$<Kjønnskode={'2'},År={\$(=\$(vMidyear))}>} [Folkemengde_3112])*-1,'#.##0;#.##0')

I want the chart to display negative values as positive and try to achieve this with the num funciton.

My problem is that the num function does not do what I want.  Something wrong with my use of the function? Any other solution?

Labels (2)

• ### Negative values

1 Solution

Accepted Solutions
MVP
14 Replies
Specialist III

try FABS

Channa
Specialist II

Do not Multiply women values with -1

Try : For women: num(sum({\$<Kjønnskode={'2'},År={\$(=\$(vMidyear))}>} [Folkemengde_3112]),'#.##0;#.##0')

Partner
Author

That did not work. The numbers ended as genuine positive values and the chart displayed the sum of men an women. What I want is a pure display mechanism.

Partner
Author

No. Women's value must be multiplied by -1. If not, there will be no population pyramid.

MVP
Number formatting should have worked. Could you please share your sample app to check?
Partner
Author