topic Re: floor in load in QlikView

floor in load

JMAROUF — Sat, 16 Nov 2024 03:19:22 GMT

Hi every one;

i have a problem with Floor() function in Load , i need to eliminate decimals , the output is 8.0 instead of 8.

can any one help please.

Re: floor in load

m_woolf — Wed, 12 Jun 2019 11:45:45 GMT

num(floor(YourField),'#,###')

Re: floor in load

sunny_talwar — Wed, 12 Jun 2019 11:53:08 GMT

Just use Num() function to not show any decimals.

Num(Floor(....), '#')

Re: floor in load

JMAROUF — Wed, 12 Jun 2019 12:24:29 GMT

Thank you for answers but i want to eliminate decimal part in calculation before the end of load's statement.

Re: floor in load

sunny_talwar — Wed, 12 Jun 2019 12:35:06 GMT

It should do that if you use that in the script... is it not doing this?

Re: floor in load

JMAROUF — Wed, 12 Jun 2019 13:45:27 GMT

Hello @sunny_talwar there is a part of script which is based on the field's value , it must be 8 instead of 8.0 for example :

if(my_field in (8,4,2..),"expression") so i will try as soon as possible

Re: floor in load

Colin-Albert — Wed, 12 Jun 2019 16:44:49 GMT

It may help if you posted your actual load script or the relevant section of it.
Then we can see how your are rounding the data in context.

Re: floor in load

JMAROUF — Thu, 13 Jun 2019 07:20:22 GMT

Hello @Colin-Albert,

this is my load script :

left join(Détail_Sin)

load

Num_Sin,

Num(floor(max(CASBAREME)),'#') as CASBAREME_SIN

resident QUIT_SIN;

the output is in the attachement.

thank you in advance;

Re: floor in load

martinpohl — Thu, 13 Jun 2019 07:26:41 GMT

Hi,

a value is a numeric field in Qlik is stored as is was loaded the first time.

So if you load

005

into your field all values are shown as 5.

If you load

005

then it is stored as 05.

Qlik also join 5 and 05 because it is the same (numeric) value.

So maybe your .0 values are from another source?

regards