3 Replies Latest reply: Sep 8, 2013 12:20 PM by Jason Michaelides RSS

    source file with diffenrent formats as the content of one field

    Mark Munich

      Hello community,

       

      I have a source file with diffenrent formats as the content of one field:

       

      For example :     

       

      Values:

      0,5

      0,705

      1. 31.12.2012
      2. 12.05.2013

      0,4

       

      If I want to show this table in QlikView I have to choose between the formats. Either I just can show the data as values than the dates are shown also as values or I can just show dates and the values are transformed to dates too.

       

      I need a solution where I can show both data formats.

       

      1. Thanks.