8 Replies Latest reply: Aug 23, 2010 4:58 AM by msadrikhcb RSS

    Displaying different data types under one column

      I am loading data from an xls. It has some columns that need to represent both integer values as well as percentage values. For example, it has values as follows;

      456,766

      34,566

      26%

      17.5%

      When I load them into Qlikview onto a pivot table, I either get all integer values or all percentage values.

      There have been previous posts and I have tried the solution but they have not worked for me.

      I have also tried the following steps

      - Document properities

      - Numbers tab

      - Mark the field in question

      - Uncheck "Survive reload"

      - Reload the document

      but it does not work, and the first time I tried it the entire pivot table got cleared.

      Can someone please advise me on what to do?

      Thanks