This content has been marked as final. Show 2 replies
I have a xls file where I have in column an allocation percentage that is stored in xls with a decimal - 2.5% - but displayed without - 3% -. When I load this file in QlikView, I have the value 0.03000 while I would like to obtain 0.02500.
The instruction to load the file is
Crosstable (Week_Text, Allocation, 2)
Load Employee, Project,
, , , .......
Any suggestion ?