topic Format for displaying negative numbers in () in QlikView

Format for displaying negative numbers in ()

sonikajain — Tue, 08 May 2012 14:16:28 GMT

Hi all,

In one of my requirements, I need to display negative numbers in brackets for specific rows. I am using 'IF ' for this in expressions and the num () function - with format '#.#%;(#.#%), but it is giving me discrepnacies in result as in -

for Num (-1.4,'#.#%;(#.#%)') result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%

Please help me on this.

Sonika

Format for displaying negative numbers in ()

sonikajain — Tue, 08 May 2012 14:56:17 GMT

for Num (-1.4,'#.#%;(#.#%)') result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%

Format for displaying negative numbers in ()

Nicole-Smith — Tue, 08 May 2012 16:52:08 GMT

Num (1.4,'#.#;(#.#)') &'%'

Re: Format for displaying negative numbers in ()

CELAMBARASAN — Tue, 08 May 2012 21:01:54 GMT

Hi,

You should use like this

=Num (1.4/100,'#.#%;(#.#)%')

=Num (1.4/100,'#.#;(#.#)')&'%'

Re: Format for displaying negative numbers in ()

Fri, 26 Apr 2013 06:27:53 GMT

Hi,

In the Properties Tab of the chart,

Goto Number Tab,sleect the expression

goto Fixed to and paste the below format in the format pattern.

#.##0,00; (#.##0,00)

Regards,

Snehal Nabar