topic Re: Negative % in bracket format does not show correctly in QV 12 SR5. in QlikView

Negative % in bracket format does not show correctly in QV 12 SR5.

NZFei — Thu, 17 Aug 2017 23:12:32 GMT

Hello,

When defining the number format to #,##0.00%;(#,##0.00%) so basically show negative % in bracket format, the negative % doesn't show correctly.

See attached the sample app, the correct result should be (16.67%) but it shows (0.1667%)

Showing negative % in bracket is a common way to show especially PNL report. Can anyone help please?

Thank you very much!

Fei

NZFei — Thu, 17 Aug 2017 23:14:25 GMT

If we export the table to Excel file, the result is correct:

So the correct number is there but the format to show it in QV does not work correctly.

Thanks.

Fei

vishsaggi — Fri, 18 Aug 2017 00:54:44 GMT

Try this?

NZFei — Fri, 18 Aug 2017 01:03:22 GMT

Thank you for your reply. I know your solution works but it is not exactly what our client wants.

They want the negative % to show like (16,67%), not (16.67)%.

Cheers.

Fei

vishsaggi — Fri, 18 Aug 2017 01:08:34 GMT

Check this attached?

NZFei — Fri, 18 Aug 2017 01:12:07 GMT

That is not even right, my friend.

Because when you export the table to Excel, it looks like this:

You actually changed the correct result to wrong.

Thanks.

Fei

vishsaggi — Fri, 18 Aug 2017 01:27:31 GMT

Hmmm not sure. Will this work for you?

NZFei — Fri, 18 Aug 2017 02:22:29 GMT

Thanks Vishwarath, I have modified it a little as a workaround:

=if((sum(F2)-sum(F1))/sum(F1)>=0,

'(' & Round(Num((((sum(F2)-sum(F1))/sum(F1))) )*100, 0.01) & '%)',

'(' & Round(Num((((sum(F2)-sum(F1))/sum(F1))) )*-100, 0.01) & '%)'

)

I have reported this to Qlik and let's see what they say about this.

Cheers.

Fei