Round Loading??

[#1]

Hi all, In have a question, I have a table, one of the fields contains decimals, but when I load it in qlikview, it rounds it. but I need to get the values in decimals, does any body know why QV does that? how could I get de original decimal values?

I attahced my app for a better understand.

in the selection already made in the field "Cantidad Componente" it´s sopoused to be 4.5 but it returns 5.

Thank you four your time!!

[#2 · Accepted solution]

Hi,  maybe because you set decimal with a '.'  ;    SET DecimalSep='.';  

Try  instead

SET DecimalSep=',' ;  

Check in the excel file how the data is formatted

JJ