Round Loading??

Wed, 11 Jan 2012 18:14:53 GMT

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!!

Round Loading??

Wed, 11 Jan 2012 18:34:32 GMT

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

Try instead

SET DecimalSep=',' ;

Check in the excel file how the data is formatted

topic Round Loading?? in QlikView

Round Loading??

Round Loading??