4 Replies Latest reply: Mar 16, 2015 9:46 AM by janaki kovvuri RSS

    Field Information?

      Hi all,

       

      I am asking a question which is not related to Qlikview, It relates to data finding. Please help me. I got table as described below, How to find actual sales from this, and here 'balance to purchase order' field contains positive and Negative values which is confusing me, can any one tell what does it mean.

       

      Balance to ReceiveBalance to Purchase OrderBalance to Invoice
      1.700-0.3390
      00.9070
      2.270-0.4560
      1.130-0.2230
      1.130-0.2230
      00.9070
      1.130-0.2230
      2.270-0.4560
      0.950-2.00011.050
      12.000-2.0000
      02.0000
      01.0000
      04.5000
      02.5000
      01.0000
      02.5000
      01.0000
      01.5000
      01.0000
      02.0000
      01.5000
      01.0000
      01.0000
      00.5000
      01.5000
      01.0000
      1.003-0.3000.797
      00.5000
      03.5000
      -0.203-1.1272.330
      00.5000
      01.0000
      1.200-0.2000
      01.5000
      05.5000
      01.5000
      02.5000
      01.0000
      04.0000
      00.5000
      00.5000
      03.5000
      1.0480.4520
      0-0.4303.430
      0-0.3801.380
      01.0000
      00.0200.480
      01.5000
      0-0.3801.380
      1.200-0.2000
      0-0.1250.625
      0.625-0.1250
      01.0000
      0-0.2900.790
      0-0.1250.625
      01.5000
      0-0.2251.225
      0-0.6802.180
      1.200-0.2000
      1.225-0.2250
      1.230-0.2300
      0-0.2501.250
      1.225-0.2250
      1.200-0.2000
      2.500-0.5000
      1.225-0.2250
      4.325-0.8250