topic Re: Chart - show negative value positive in QlikView

Chart - show negative value positive

Fri, 18 Oct 2013 12:45:39 GMT

Hey,

On the first i hope you can excuse my english because it's not my maternal language and maybe my question. I search a lot on community without response.

I create an age pyramid on a single chart who make a difference between man and women. For show the differences I make a man's numbers negative. I would like in my chart show this value positive.

I already try different number format without success.

Do you have an idea, a solution ?

Thanks for your help.

Re: Chart - show negative value positive

rajni_batra — Fri, 18 Oct 2013 12:49:41 GMT

use fabs() function hope this could help u

from QV Help :

fabs( x )

The absolute value of x. The result
is a positive number.

Examples:

fabs( 2.4 ) returns 2.4

fabs( -3.8 ) returns
3.8

Regards,

Rajni

Re: Chart - show negative value positive

MayilVahanan — Fri, 18 Oct 2013 12:54:11 GMT

Try like this

fabs() which converts negative to positive number

Re: Chart - show negative value positive

CELAMBARASAN — Fri, 18 Oct 2013 12:55:11 GMT

You could change it in Number formatting tab.For both positive and negative as same

#,###;#,###

Re: Chart - show negative value positive

Fri, 18 Oct 2013 12:58:53 GMT

Celambarasan thanks for you answer that's work perfectly.

For they other answer, if you use fabs() in your expression that's convert value before to show them and i would like only visualy.

Thanks a lot everybody.

Re: Chart - show negative value positive

rajni_batra — Fri, 18 Oct 2013 13:12:41 GMT

no but fabs() can be used outside complete expression this is also for visual purpose.

you can use it like

fabs(sum(A)/Sum(B))... it will change - to + only after calculation of expression.

Regards,

Re: Chart - show negative value positive

Fri, 18 Oct 2013 13:22:20 GMT

Rajni,

I try on a graph to use it without sucess. It's transform value in positive value. My purpose, it's negative value stay a negative value but visually you saw a positive value.

Thanks,