Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marisolacostah
Contributor
Contributor

field is 17 numeric positions with rounding

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)

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
MarcoWedel

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

Do you intend to perform calculations on those numbers?

marisolacostah
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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