Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Receive | Balance to Purchase Order | Balance to Invoice |
1.700 | -0.339 | 0 |
0 | 0.907 | 0 |
2.270 | -0.456 | 0 |
1.130 | -0.223 | 0 |
1.130 | -0.223 | 0 |
0 | 0.907 | 0 |
1.130 | -0.223 | 0 |
2.270 | -0.456 | 0 |
0.950 | -2.000 | 11.050 |
12.000 | -2.000 | 0 |
0 | 2.000 | 0 |
0 | 1.000 | 0 |
0 | 4.500 | 0 |
0 | 2.500 | 0 |
0 | 1.000 | 0 |
0 | 2.500 | 0 |
0 | 1.000 | 0 |
0 | 1.500 | 0 |
0 | 1.000 | 0 |
0 | 2.000 | 0 |
0 | 1.500 | 0 |
0 | 1.000 | 0 |
0 | 1.000 | 0 |
0 | 0.500 | 0 |
0 | 1.500 | 0 |
0 | 1.000 | 0 |
1.003 | -0.300 | 0.797 |
0 | 0.500 | 0 |
0 | 3.500 | 0 |
-0.203 | -1.127 | 2.330 |
0 | 0.500 | 0 |
0 | 1.000 | 0 |
1.200 | -0.200 | 0 |
0 | 1.500 | 0 |
0 | 5.500 | 0 |
0 | 1.500 | 0 |
0 | 2.500 | 0 |
0 | 1.000 | 0 |
0 | 4.000 | 0 |
0 | 0.500 | 0 |
0 | 0.500 | 0 |
0 | 3.500 | 0 |
1.048 | 0.452 | 0 |
0 | -0.430 | 3.430 |
0 | -0.380 | 1.380 |
0 | 1.000 | 0 |
0 | 0.020 | 0.480 |
0 | 1.500 | 0 |
0 | -0.380 | 1.380 |
1.200 | -0.200 | 0 |
0 | -0.125 | 0.625 |
0.625 | -0.125 | 0 |
0 | 1.000 | 0 |
0 | -0.290 | 0.790 |
0 | -0.125 | 0.625 |
0 | 1.500 | 0 |
0 | -0.225 | 1.225 |
0 | -0.680 | 2.180 |
1.200 | -0.200 | 0 |
1.225 | -0.225 | 0 |
1.230 | -0.230 | 0 |
0 | -0.250 | 1.250 |
1.225 | -0.225 | 0 |
1.200 | -0.200 | 0 |
2.500 | -0.500 | 0 |
1.225 | -0.225 | 0 |
4.325 | -0.825 | 0 |
Hello Janaki,
I think you better go back to the source of your specific dataset, and ask him/her the questions you raised here.
Regards,
johan
Is this what you have got or there are other part of this data?
might be----> field1+field2+field3
Thank you will do