4 Replies Latest reply: May 5, 2016 1:12 PM by Jonas Melo RSS

    Loading problems on Qlikview

    Ana Vieira

      Hello,

       

      I'm having a strange problem in load process.

      I'm running an Informix stored procedure that creates a temporary table. I do a select to the temporary table to get all records, no filter, no calculations in this process.

      The problem is that I have some columns from the record that should have value zero but Qlikview fills with values from another record!

      If I run the process and select only the record that have zeros, in Qlikview appears with zeros If I select more than one record, zero values are substituted with other values.

       

      Ex.

      Running the query and getting all records columns volume, valgrosseur, valgrossmoe and prevdescfineur assume values diferente from zero.

       

      mes product_id ship_mthd sales_type volume valgrosseur valbonuseur valgrossmoe prevdescfineur
      4NUN08003031CUTOFF2ADD2,4952330,00000161,240002330,000000142,90000
      4NUN08003033VENDA-23,96-20262,4100084,64000-15763,20000051,36000

       

      Running the query with filter to get only the second row the columns have the right values on all columns.

      mes product_id ship_mthd sales_type volume valgrosseur valbonuseur valgrossmoe prevdescfineur
      4NUN08003033VENDA00,0000084,640000,0000000,00000

       

       

      Thanks in advance for your help.