Decimal value

[rahulsud007]

Dear experts,

I have an issue related to decimal field. I have two fields having value

2.1   abc

2.2    xyz

2.3,

2.4,

2.5,

2.6,

2.7,

2.8,

2.9,

2.10  pqr

The issue is that qlikview takes the value 2.1 abc  and  2.1 pqr, 

while I need the output as 2.1 abc and 2.10  pqr. Please help me in this

[avinashelite]

check this example

[rahulsud007]

Hi guys here is the sample data

[swuehl]

I believe your issue arise from the fact that the cell value in your excel file is the same, '2,1', only formatted differently (first with minimum decimal places, second with two decimal places).

QV will just read in the number from the excel file, not the format.

[avinashelite]

hi,

As i checked ,its the issue with excel formatting for the display they are showing it as 2.10 but the formal is deserving it as 2.1 hence Qlikview is treating the same.

before loading format the excel column as text that will load the data properly