2 Replies Latest reply: Nov 27, 2012 12:21 PM by Mayil Vahanan Ramasamy RSS

    Field Format issue

    Alec Harf

      Hi Guys,

       

      I am loading data from a SP List and one of the fields is Money formatted on the source.

      when imported to QlikView I get the data to look like:

       

      Revenue                                                       On the Source

      float;#200.00000000                                        $200.00

      float;#75.000000000                                        $75.00

      float;#5000.0000000                                        $5000.00

       

       

       

      not sure why I am getting the"float;#" before the nr

      I tried to format the field in the in the script as Num() but didn't help.

      Anybody has experienced any simillar issue.

       

      Thxs for your help.

      Alec