Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vireshkolagimat
Contributor III

Negative number formatting

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

7 Replies
MVP
MVP

Re: Negative number formatting

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vireshkolagimat
Contributor III

Re: Negative number formatting

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

ecolomer
Honored Contributor II

Re: Negative number formatting

In the Numeric label descheck and check option See in %

Look at the file

vireshkolagimat
Contributor III

Re: Negative number formatting

yes i got it. thank you.

Chanty4u
Esteemed Contributor III

Re: Negative number formatting

try to check here

Rounding Errors

HirisH_V7
Honored Contributor

Re: Negative number formatting

Hi vireshkolagimath‌ ,

Please close the thread by marking correct answer.

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
ecolomer
Honored Contributor II

Re: Negative number formatting

Hi vireshkolagimath ,

Please close the thread by marking correct answer.

TX's

Saludos

Enrique