How to display values of different data types in one column?

[#1]

I am loading data from an xls. It has one column known as 'DIFF'. This column has percent as well as integer values. For example, it has values as follows:

DIFF

20%

0

1

50%

When I load this data into Qlikview, all the values are converted to percentages by Qlikview while loading. So, value 0 is converted to 0% and 1 to 100%, instead of the original values of 0 and 1 respectively.

Please let me know, how can I display the actual values, that is i want to show the both the percent and integer values in this column. Pls. guide.

[#2]

We have check it's not working.

Regards

Ashish Srivastava

[#3]

Hi

It´s works for me.

See attach document

Anders

[#4]

Hi Anders.

Thanks so much for your reply.

I have tested this with my xls. It is working....:-)

Thanks again...

Regards,

Swati

[#5]

Hi Ashish,

Its working for me.

Regards,

Swati

[#6]

Hi Swati

When i run in my qlikview 10 beta version it's not working but when i run same thing in qlikview 8.5 it's

working fine .

Regards

Ashish Srivastava

[#7]

Hi Ashish,

I am using Qlikview version 9 SR4, and its working in this version.

Regards,

Swati