25 Replies Latest reply: Jul 15, 2010 3:31 AM by swatisinha17 RSS

    How to display values of different data types in one column?

    swatisinha17

      I am loading data from an xls. It has one column known as 'DIFF'. This column has percent as well as integer values. For example, it has values as follows:

      DIFF

      20%

      0

      1

      50%

      When I load this data into Qlikview, all the values are converted to percentages by Qlikview while loading. So, value 0 is converted to 0% and 1 to 100%, instead of the original values of 0 and 1 respectively.

      Please let me know, how can I display the actual values, that is i want to show the both the percent and integer values in this column. Pls. guide.