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

[awhitfield]

Load the value as text in your load script.

HTH Andy

[MayilVahanan · Accepted solution]

hi

Try with

Text(FieldName1) as FieldName1;

Hope it helps

[swuehl]

These two values are the same number for QV, and there is only one format for a single number.

You can use

LOAD

text(FIELD1) as FIELD1,

FIELD2,

...

to read the numbers in as text.

[avinashelite]

Hi Rahul,

Try to load value with dual i.e one as text and one as number.

dual(text(numberfield),numberfield)

[rahulsud007]

Hi All, I tried loading field using text still the same.

[rahulsud007]

Text(Wbs) as wBS

[avinashelite]

can you share the app with sample data

[swuehl]

What is your data source?

edit: Here is a sample for an INLINE LOAD:

LOAD Text(Field1) as Field1, Field2

INLINE [

Field1, Field2

2.1,   abc

2.2,    xyz

2.3,

2.4,

2.5,

2.6,

2.7,

2.8,

2.9,

2.10,  pqr

];

[awhitfield]

Hi Rahul,

can you upload your qvw and sample date? Or failing that; your data and the relevant script please?

Andy