topic Re: Remove Decimals in QlikView

Remove Decimals

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Needed help with the following please.

I am getting the current and want the ones listed below

so i get 78.8 but want 78 etc

Is there a function for this in the code please?

Thanks

Anonymous — Tue, 12 Jul 2016 15:06:44 GMT

floor is the function you would use.

Anonymous — Tue, 12 Jul 2016 15:07:29 GMT

I tried this and in a stright table it changes my number from 78.8 to 20?

ThornOfCrowns — Tue, 12 Jul 2016 15:09:07 GMT

Set the Number Type to Integer in the Table Properties.

Anonymous — Tue, 12 Jul 2016 15:11:36 GMT

see the attached sample file which will help you

Anonymous — Tue, 12 Jul 2016 15:15:13 GMT

if it is in straight table, follow the attached screen shot

sunny_talwar — Tue, 12 Jul 2016 15:20:12 GMT

Floor(YourCurrentExpression) changed the number from 78 to 20???

Anonymous — Tue, 12 Jul 2016 16:10:37 GMT

Thanks Everyone for the replies!