Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
a value is a numeric field in Qlik is stored as is was loaded the first time.
So if you load
5
05
005
into your field all values are shown as 5.
If you load
05
005
5
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
num(floor(YourField),'#,###')
Just use Num() function to not show any decimals.
Num(Floor(....), '#')
Thank you for answers but i want to eliminate decimal part in calculation before the end of load's statement.
It should do that if you use that in the script... is it not doing this?
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
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.
Hello @Colin-Albert,
this is my load script :
Hi,
a value is a numeric field in Qlik is stored as is was loaded the first time.
So if you load
5
05
005
into your field all values are shown as 5.
If you load
05
005
5
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