2 Replies Latest reply: Mar 15, 2011 8:08 AM by jmmathieu RSS

    Excel - CrossTable - Problem of Loading of percentage values with decimals

    jmmathieu

      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,

      [40550], [40557], [40564], .......

      from ....

      Any suggestion ?

      Thank you,

      JM