Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

4 Replies
puttemans
Valued Contributor

Re: Field Information?

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?

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

buzzy996
Honored Contributor II

Re: Field Information?

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

Not applicable

Re: Field Information?

Thank you will do

Community Browser