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: 
jelindbe
Partner - Contributor III
Partner - Contributor III

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?befpyr.png

 

Labels (2)
1 Solution

Accepted Solutions
16 Replies
Channa
Specialist III
Specialist III

try FABS

 

Channa
anushree1
Specialist II
Specialist II

Do not Multiply women values with -1 

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

jelindbe
Partner - Contributor III
Partner - Contributor III
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.

jelindbe
Partner - Contributor III
Partner - Contributor III
Author

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

tresesco
MVP
MVP

Number formatting should have worked. Could you please share your sample app to check?
jelindbe
Partner - Contributor III
Partner - Contributor III
Author

Where do I upload?
tresesco
MVP
MVP

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

jelindbe
Partner - Contributor III
Partner - Contributor III
Author

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

tresesco
MVP
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.