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: 
Not applicable

Resultado Inteiro

Boa tarde!

Alguém já precisou obter apenas a parte "inteira" de algum calculo matemático no qlik? Ex:

=sum(Desl_franquia)*1.4

Este calculo eventualmente me retorna um número do tipo 16,4 , ou 16,8 . Preciso que apareça somente o 16, sem ser arredondado. Olhei várias funções, mas elas ou arredondam para baixo ou para cima, e na verdade não posso ter arredondamentos.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

if I understand your question, try with function

floor

this is from Qlik help

floor(x [ , base [ , offset ]])

Rounding of x downwards to the nearest multiple of base with an offset of offset. The result is a number.

Examples:

floor( 2.4 ) returns 2

floor( 2.6 ) returns 2

floor( 3.88 , 0.1 ) returns 3.8

floor( 3.88 , 5 ) returns 0

floor( 1.1 , 1 , 0.5 ) returns 0.5

View solution in original post

2 Replies
maxgro
MVP
MVP

if I understand your question, try with function

floor

this is from Qlik help

floor(x [ , base [ , offset ]])

Rounding of x downwards to the nearest multiple of base with an offset of offset. The result is a number.

Examples:

floor( 2.4 ) returns 2

floor( 2.6 ) returns 2

floor( 3.88 , 0.1 ) returns 3.8

floor( 3.88 , 5 ) returns 0

floor( 1.1 , 1 , 0.5 ) returns 0.5

Not applicable
Author

Yes, this is it. Strange that I had tried the floor but had not worked when I used.

Anyway, thank you for help, even if it was I needed.