4 Replies Latest reply: Sep 9, 2016 12:44 PM by Ugonna Okoli RSS

    sum column incorrect

    michele della mea

      I must load from a csv file to qlik sense a csv table in this way:

       

      [dashboard_data]:

      LOAD [giorno_full],

        [anno],

        [mese],

        [giorno],

        [cliente_id],

        [cliente],

        [zona_id],

        [zona],

        [struttura_id],

        [struttura],

        [area_id],

        [area],

        Num#(cost,'0.00') as costo,

        Num#(revenue,'0.00') as ricavo

      FROM [lib://prove/dashboard_data.csv]

      (txt, utf8, embedded labels, delimiter is ';', msq);

       

      This is the head of the csv file:

       

      "giorno_full";"anno";"mese";"giorno";"cliente_id";"cliente";"zona_id";"zona";"struttura_id";"struttura";"area_id";"area";"cost";"revenue"

      "2014-06-13";2014;6;13;36;"DOLOMITI4U DI GHEDINI BRUNO";9;"Cortina d'Ampezzo";22;"Dolomiti4u";30;"Area Veneto 1";56.98;60.00

      "2014-06-16";2014;6;16;36;"DOLOMITI4U DI GHEDINI BRUNO";9;"Cortina d'Ampezzo";22;"Dolomiti4u";30;"Area Veneto 1";77.93;88.00

      "2014-06-18";2014;6;18;36;"DOLOMITI4U DI GHEDINI BRUNO";9;"Cortina d'Ampezzo";22;"Dolomiti4u";30;"Area Veneto 1";83.91;96.00

      "2014-06-19";2014;6;19;36;"DOLOMITI4U DI GHEDINI BRUNO";9;"Cortina d'Ampezzo";22;"Dolomiti4u";30;"Area Veneto 1";24.06;0.00

       

      However when I create a measure with "sum(revenue)" or "sum(cost) the sum is incorrect (incredibly high)... which are the reasons? There are other ways to find those sums?