topic Re: Negative number formatting in QlikView

Negative number formatting

vireshkolagimat — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I have attached set of data and i am using straight table to show the data. The source data is in percentage format and i want to show the numbers in percentages and negative numbers in brackets to one decimal places.

I am able to show the numbers in percentages but when i apply the negative number formationg, the values are rounding.

attached is the data set and qvw file for your reference.

Regards,

Viresh

Re: Negative number formatting

jonathandienst — Tue, 23 Aug 2016 05:11:34 GMT

Use the formatting string 0.0%;(0.0%) (assuming your default format uses a decimal point; change to a comma for a decimal comma).

Re: Negative number formatting

vireshkolagimat — Tue, 23 Aug 2016 05:17:38 GMT

Hi, I tried to apply above formatting to the change column but still the result is not changing.

Re: Negative number formatting

ecolomer — Tue, 23 Aug 2016 05:22:48 GMT

In the Numeric label descheck and check option See in %

Look at the file

Re: Negative number formatting

vireshkolagimat — Tue, 23 Aug 2016 05:33:12 GMT

yes i got it. thank you.

Re: Negative number formatting

Chanty4u — Tue, 23 Aug 2016 05:37:15 GMT

try to check here

Rounding Errors

Re: Negative number formatting

HirisH_V7 — Tue, 23 Aug 2016 05:38:10 GMT

Hi vireshkolagimath‌ ,

Please close the thread by marking correct answer.

-Hirish

Re: Negative number formatting

ecolomer — Tue, 23 Aug 2016 05:59:15 GMT

Hi vireshkolagimath ,

Please close the thread by marking correct answer.

TX's

Saludos

Enrique