Display negative numbers as positive

[jelindbe]

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?

[jelindbe]

I don't see what you mean.

[tresB · Accepted solution]

PFA

[julis]

In my qlik version the numbers are showing negative values

[tresB]

Could post your expression and output you are getting?

[julis]

Solved, thank you

[Justin-Sherborne]

Where is the answer for this?  Can it be posted as text in this thread please

[Justin-Sherborne]

I solved what I wanted by using a Custom Number formatting in my measure:  Format pattern #,##0; #,##0