topic Re: negative number in brackets in QlikView

negative number in brackets

rcandeo — Fri, 26 Aug 2016 11:55:54 GMT

I have a text object that I wanna show as number with % and when it´s negative I wanna it in brackets.

It works if the result is +20.29%, but if the result is (8.85%) it shows (0.09%)

The expression is as below:

=num((

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vCurrentYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)))

sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)),

[Broker Pack Region]))

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)))

sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)),

[Broker Pack Region])))*100

,'+ ###.##%;(###.##%);-')

Any idea what to do?

Re: negative number in brackets

Anil_Babu_Samineni — Fri, 26 Aug 2016 12:08:06 GMT

As i got, If you got +ve value then 12.43%

Meantime, While selection if you got -Ve value then (-12.43%) -- Is this you are expecting? Or What

Re: negative number in brackets

rcandeo — Fri, 26 Aug 2016 12:18:49 GMT

sorry not being more clear. With positive(+) value then works.With negative(-) values it is showing divided by 100, so when should see (12.43%) it shows (0.12%)

Re: negative number in brackets

Anil_Babu_Samineni — Fri, 26 Aug 2016 12:20:45 GMT

It's tricky t explain, Can you post sample application which demonstrates the issue

Re: negative number in brackets

sunny_talwar — Fri, 26 Aug 2016 12:26:54 GMT

How about this:

=Num((

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vCurrentYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)))

sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)),

[Broker Pack Region]))

max(Aggr(

(sum({<[Reporting Calendar Year] = {'$(vPriorYear)'}>} $(vCurrency)) - sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)))

sum({<[Reporting Calendar Year] = {'$(vPriorYearBefore)'}>} $(vCurrency)),

[Broker Pack Region])))*100

,'+###.##%;(###.##%)')

Re: negative number in brackets

stigchel — Fri, 26 Aug 2016 12:28:03 GMT

Use

Num(YourExpression,'+ ###.##%;(###.##)%')

watch the place of the ) and %

Re: negative number in brackets

rcandeo — Fri, 26 Aug 2016 12:47:30 GMT

This works. Thank you so much

Re: negative number in brackets

rcandeo — Fri, 26 Aug 2016 12:47:51 GMT

thank you but didn´t work

Re: negative number in brackets

rcandeo — Fri, 26 Aug 2016 12:48:10 GMT

thank you. it´s solved