Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

rahulsud007
Contributor

Decimal value


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

Tags (3)
1 Solution

Accepted Solutions
Highlighted

Re: Decimal value

hi

Try with

Text(FieldName1) as FieldName1;

Hope it helps

View solution in original post

13 Replies
Highlighted
Partner
Partner

Re: Decimal value

Load the value as text in your load script.

HTH Andy

Highlighted

Re: Decimal value

hi

Try with

Text(FieldName1) as FieldName1;

Hope it helps

View solution in original post

Highlighted
MVP
MVP

Re: Decimal value

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.

Highlighted

Re: Decimal value

Hi Rahul,

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

dual(text(numberfield),numberfield)

Highlighted
rahulsud007
Contributor

Re: Decimal value

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

Highlighted
rahulsud007
Contributor

Re: Decimal value


Text(Wbs) as wBS

Highlighted

Re: Decimal value

can you share the app with sample data

Highlighted
MVP
MVP

Re: Decimal value

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

];

Highlighted
Partner
Partner

Re: Decimal value

Hi Rahul,

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

Andy