field is 17 numeric positions with rounding

[marisolacostah]

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)

[Gysbert_Wassenaar · Accepted solution]

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

[MarcoWedel]

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

Do you intend to perform calculations on those numbers?

[marisolacostah]

Appreciable marcowedel ‌

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

I do not want it for calculations.

thank you very much.

[MarcoWedel]

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

[marisolacostah]

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.

[MarcoWedel]

what data source do you have?

[marisolacostah]

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