Field Information?

Mon, 16 Mar 2015 12:39:38 GMT

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

Re: Field Information?

puttemans — Mon, 16 Mar 2015 12:56:21 GMT

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

Re: Field Information?

robert_mika — Mon, 16 Mar 2015 12:59:13 GMT

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

Re: Field Information?

buzzy996 — Mon, 16 Mar 2015 13:06:23 GMT

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

Re: Field Information?

Mon, 16 Mar 2015 13:46:59 GMT

Thank you will do

topic Field Information? in QlikView

Field Information?

Re: Field Information?

Re: Field Information?

Re: Field Information?

Re: Field Information?