topic Re: Decimal value in QlikView

Decimal value

rahulsud007 — Wed, 17 Jun 2015 12:39:52 GMT

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

Re: Decimal value

awhitfield — Wed, 17 Jun 2015 12:42:31 GMT

Load the value as text in your load script.

HTH Andy

Re: Decimal value

MayilVahanan — Wed, 17 Jun 2015 12:42:43 GMT

Try with

Text(FieldName1) as FieldName1;

Hope it helps

Re: Decimal value

swuehl — Wed, 17 Jun 2015 12:43:38 GMT

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.

Re: Decimal value

avinashelite — Wed, 17 Jun 2015 12:44:28 GMT

Hi Rahul,

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

dual(text(numberfield),numberfield)

Re: Decimal value

rahulsud007 — Wed, 17 Jun 2015 12:51:39 GMT

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

Re: Decimal value

rahulsud007 — Wed, 17 Jun 2015 12:52:55 GMT

Text(Wbs) as wBS

Re: Decimal value

avinashelite — Wed, 17 Jun 2015 12:53:56 GMT

can you share the app with sample data

Re: Decimal value

swuehl — Wed, 17 Jun 2015 12:54:10 GMT

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

];

Re: Decimal value

awhitfield — Wed, 17 Jun 2015 12:54:29 GMT

Hi Rahul,

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

Andy

Re: Decimal value

avinashelite — Wed, 17 Jun 2015 12:57:42 GMT

check this example

Re: Decimal value

rahulsud007 — Wed, 17 Jun 2015 13:08:24 GMT

Hi guys here is the sample data

Re: Decimal value

swuehl — Wed, 17 Jun 2015 13:27:08 GMT

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.

Re: Decimal value

avinashelite — Wed, 17 Jun 2015 13:27:56 GMT

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