topic Re: field is 17 numeric positions with rounding in QlikView

field is 17 numeric positions with rounding

marisolacostah — Thu, 16 Aug 2018 14:15:05 GMT

Hello everyone,

I have problems when formatting a field and when doing the extraction the field is passed in scientific notation, the length of the field is 17 numerical positions, I did what I found in the community but those that have come to give me a bit of result this is not correct, since it rounds the number, how can I get it without rounding?, I attach my file qvd and qvw.

example:

correct:19180000183616413

incorrect:19180000183616412

used functions:

1.-=Floor(HICTAB)

2.-=Round(HICTAB)

3.-=CEIL(HICTAB)

4.=num(HICTAB)

5.=round(num#(HICTAB,'#,#',',','.'))

6.=num(HICTAB,0)

7.=num(HICTAB,'##############################')

8.=num(HICTAB,'(dec)')

9.=Round(HICTAB,18)

10.=num(HICTAB,'#,#####',',','.')

11.= Div(HICTAB, 1e10) & left(repeat('0',10), 10 - len(text(Mod(HICTAB, 1e10)))) & Mod(HICTAB, 1e10)

En español*

Hola a todos,

tengo problemas al dar formato a un campo y al momento de hacer la extraccion el campo lo pasa en notación científica, la longitud del campo es de 17 posiciones numéricas, realice lo que encontré en la comunidad pero los que me han llegado a dar un poco de resultado este no es correcto, ya que redondea el numero, ¿como puedo obtenerlo sin redondeos?, adjunto mi archivo qvd y qvw.

ejemplo:

correcto:19180000183616413

incorrecto:19180000183616412

funciones usadas:

1.-Floor(HICTAB)

2.-Round(HICTAB)

3.-CEIL(HICTAB)

4.num(HICTAB)

5.round(num#(HICTAB,'#,#',',','.'))

6.num(HICTAB,0)

7.num(HICTAB,'##############################')

8.num(HICTAB,'(dec)')

9.Round(HICTAB,18)

10.num(HICTAB,'#,#####',',','.')

11.Div(HICTAB, 1e10) & left(repeat('0',10), 10 - len(text(Mod(HICTAB, 1e10)))) & Mod(HICTAB, 1e10)

Re: field is 17 numeric positions with rounding

Gysbert_Wassenaar — Thu, 16 Aug 2018 17:30:55 GMT

Afaik all numbers in Qlikview are IEEE 754 Floating Point numbers. See this blog post: Rounding Errors

Re: field is 17 numeric positions with rounding

MarcoWedel — Thu, 16 Aug 2018 21:22:54 GMT

Why do you need it to be a number instead of some text?

Do you intend to perform calculations on those numbers?

Re: field is 17 numeric positions with rounding

marisolacostah — Fri, 17 Aug 2018 14:06:02 GMT

Appreciable marcowedel ‌

In case you want it as text, how would it be?

I do not want it for calculations.

thank you very much.

Re: field is 17 numeric positions with rounding

MarcoWedel — Fri, 17 Aug 2018 19:55:34 GMT

You could load this field from your data source using the Text() function.

Re: field is 17 numeric positions with rounding

marisolacostah — Mon, 20 Aug 2018 14:53:48 GMT

Hi marcowedel,

I already use the text () function and I still send the field as if it were a scientific number.

I have not yet found the request to my problem and I have time to solve it, I do not know what other way I can get with the result.

Re: field is 17 numeric positions with rounding

MarcoWedel — Mon, 20 Aug 2018 19:55:45 GMT

what data source do you have?

Re: field is 17 numeric positions with rounding

marisolacostah — Tue, 21 Aug 2018 14:14:40 GMT

DB2/AS400, ATTACH FILE IN THREAD IF YOU NEED IT.