show numbers in %

[vireshkolagimat]

Hi,

I have data in the below format. when i try to show the change column in %, i not getting the expected result.

Header 1	Header 2	Header 3	Header 4
A	56%	60%	(4%)
B	55%	56%	(1%)
C	33%	32%	1%

the result should be the one shown i the table but i am getting 0% for both 2nd and 3rd row. how to fix this. I need to show the difference of 2nd and 3rd column in %.

Regards,

Viresh

[sunny_talwar]

What is the expression used here? and what kind of formatting is used?

[vireshkolagimat]

I am exporting the data from excel and it is shown in % in excel as well. In expression, i am just using the column names

[awhitfield]

can you upload an example please? What you ask if far too vague!

Andy

Qlik Community Tip: Posting Successful Discussion Threads

[sunny_talwar]

I am still not sure what is going on. Would you be able to share a sample or screenshots?

[Anil_Babu_Samineni]

Viresh, Try to put expression is Relative and they Go to Number tab and then Choose that expression Integer and Check the %

Or If you have calc expressions please share sample App

[vireshkolagimat]

Hey, i tried it but getting different numbers. attached is the sample data and qvw.

Thanks

[clondono]

Viresh, in the number tab select the "Change" field and set it to Fixed- 1 decimals.  See screenshot.

Regards,

Carlos

[vireshkolagimat]

Hi Carlos,

Thanks but i don't want show the decimal places .

When i try to show the negative numbers in brackets still getting 0.0% even after providing single decimal place.

Regards,

Vires