# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for
Search instead for
Did you mean:
Highlighted
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
Highlighted
MVP
14 Replies
Highlighted
Specialist III

try FABS

Channa
Highlighted
Specialist II

Do not Multiply women values with -1

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

Highlighted
Partner

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.

Highlighted
Partner

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

Highlighted
MVP
Number formatting should have worked. Could you please share your sample app to check?
Highlighted
Partner
Where do I upload?
Highlighted
MVP

Click on reply; in the new editor-> left bottom corner you would find a clip symbol to click on and upload

Highlighted
Partner

This took a while. I have now stripped down the app to include just the population pyramid. Any help would be welcome.

Highlighted
MVP
It seems that you are not doing the number formatting at the right place. Use the num() around the expression that results in negative figures.