Qlik Community

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

 

Labels (2)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

14 Replies
Highlighted
Specialist III
Specialist III

try FABS

 

Channa
Highlighted
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')

Highlighted
Partner
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
Partner

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

Highlighted
MVP
MVP

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

Where do I upload?
Highlighted
MVP
MVP

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

Highlighted
Partner
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
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.