topic Re: Get all numbers after decimal in QlikView

Get all numbers after decimal

MK9885 — Fri, 21 May 2021 11:52:12 GMT

Hi,

I have a column with numbers

1234567

1234567.1

1234567.10

987654.2

987654.20
Qlik is ignoring 0 after decimal point. Which is normal. But I want both

1234567.1 & 1234567.10 etc...

I want to bring in anything after decimal without concatenating the numbers

Re: Get all numbers after decimal

eddie_wagt — Fri, 21 May 2021 12:29:46 GMT

Hello,

Do you want these numbers as a dimension or will you use them in a expression. Display versus calculation?

Regards

Eddie

Re: Get all numbers after decimal

MK9885 — Fri, 21 May 2021 13:02:21 GMT

It's a dimension.

Re: Get all numbers after decimal

MK9885 — Fri, 21 May 2021 13:05:38 GMT

As shown below in SQL DB table,

4667547.2

4667547.20

But when I load this in Qlik, it concatenates both numbers & just giving me 4667547.2.

they are 2 separate records.

Re: Get all numbers after decimal

eddie_wagt — Fri, 21 May 2021 13:07:30 GMT

You can load this field as text if you want to use it as a dimension. Qlik automatically sees this field as numeric, so you have to explicitly tell it is text.

LOAD text([column_with_number]) as column_with_number , [other column] , [etcetera] FROM [yadiyada.qvd] (qvd);

Re: Get all numbers after decimal

eddie_wagt — Fri, 21 May 2021 13:22:51 GMT

Hello @MK9885 ,

On the first load Qlik already reads it as numeric as the source probably tells Qlik to do. You have to solve this in your SQL statement like this.

LOAD Text(Number) as Number , OTHERFIELD ; SELECT CAST(Field AS varchar) as Number , OTHERFIELD FROM SCHEME.SOURCE ;

Re: Get all numbers after decimal

MK9885 — Fri, 21 May 2021 15:39:26 GMT

Didn't though about that..

Thanks. It worked at extract level. Loading in final app to see the results.

Thanks