topic num function add +- before the number in QlikView

num function add +- before the number

Sun, 26 Oct 2014 15:41:04 GMT

Hi All,

I using the num() function in a text object and I would like to add + or - according to the calculation result. The expression is a trend current period in comparison to previous period.

I tried several options including '+#,###' and +'#,###'which didn't work.

Any ideas?

Thx!

Hila.

Re: num function add +- before the number

maxgro — Sun, 26 Oct 2014 17:52:02 GMT

=num(MyNum,'+#,##0;-#,##0')

Re: num function add +- before the number

Anonymous — Sun, 26 Oct 2014 17:55:00 GMT

Or even just like this for little less typing :

=num(MyNum,'+#,##0')

Re: num function add +- before the number

jagan — Mon, 27 Oct 2014 04:15:14 GMT

Hi,

Try like this using Num()

Syntax: Num(Number, 'Positive Number format;Negative Number format')

Example:

num(-10000,'+#,##0;-#,##0') - Output: -10,000

num(10000,'+#,##0;-#,##0') - Output: 10,000

Hope this helps you.

Regards,

Jagan.

Re: num function add +- before the number

its_anandrjs — Mon, 27 Oct 2014 06:29:05 GMT

On text box try like below expression

=if( Sum( YourMetricHere ) <= 0, '-', '+' ) & Fabs( Sum ( YourMetricHere ) )

Re: num function add +- before the number

Mon, 27 Oct 2014 06:40:18 GMT

Thx Massimo Grossi! this works great!

Re: num function add +- before the number

Mon, 27 Oct 2014 06:41:24 GMT

Hi Jegan,

I wanted to display +1000 for positive and -1000 for negative. See the marked correct answer for the syntax.

Thanks for your help!