Field Information?

[#1]

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

[puttemans]

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

[robert_mika]

Is this what you have got or there are other part of this data?

[buzzy996]

might be---->  field1+field2+field3

[#5]

Thank you will do