Interpretation of numbers like 1.4 and 1.40 in qlikview

[veeranj]

Hi All,

I have a application field and its release field and every release has its own version.

where the versions are of 1.4 and 1.40 values .

in database these versions have values as above .

but when i load it in qlikview it is showing both the values as 1.40.

Can anyone please let me know how to resolve this.

Thanks in advance.

Anjee

[iktrayanov]

maybe

Load

text(Version) as Version

........

[iktrayanov]

Also on the Number tab make sure you are not forcing Fixed To 2 decimals

[#4]

Use this

Num(Sum(Version),'##,#0.00')

[#5]

hi for this

set format like this.

num(2.30,'#.#')

then output is 2.3

********************

num(2.30,'#.##')

then output is 2.30

[sundarakumar]

In Number tab set Expression default, see to that decimal is not enabled.

-Sundar

[#7]

Hi,

  You have to Fixed to 1 Decimal in Number tab for that field,then You will get 1.4 as your Version

[veeranj]

Thanks all for ur replies
let me give an example

This is my source file.

and my script was

LOAD APPID,

     RELEASEID,

     TEXT(VERSION) AS TEXTVERSION,

     RELEASENAME,

     VERSION

FROM path;

output i am getting as

I need the output as the same as input

Thanks,

Anjee

[sundarakumar]

Please go to table viewer and see the preview , if u have got only 1.4 everywhere.

-Sundar

[veeranj]

Hi Sundarakumar,

In Table viewer data also,it is showing the same output as mentioned above.

Thanks,

Anjee