topic Calculate Volume in QlikView

Calculate Volume

upaliwije — Tue, 03 Jan 2017 14:56:27 GMT

Hi Friends,

I have two qvd files

1 . EMP.QVD ( Giving time consumend by staff to compltete job)

2. TOT_VOLUME.QVD ( Volume of work unots in Nos)

I want to create a file combining two files to calculate voume handle by staff members ( Receipt Nos and Debit Note Nos from volume file should be multified by Minutes from Emp file based on SEQ )

I have tried doing this using apply map method but It does not work properly. Pls help me to do it. I have attached my QV document and two data files pls.

Re: Calculate Volume

sunny_talwar — Tue, 03 Jan 2017 15:09:39 GMT

What is the expected output here? You have Multiple BCOD and NOS in your applymap.... Which one should be picked?

Re: Calculate Volume

upaliwije — Tue, 03 Jan 2017 15:32:26 GMT

Expected output is as follows If there is a value in Debit Notes or Dir Receipts It should be multified by Minutes.

But my problem is all records in Tot Volume is not returned whemn apply map is used

BCOD	DEBIT_NOTES	SEQ	DIR_RECEIPTS	MINUTES	Output
VU00		7	12	0.5	6
VU00		8	12	0.5	6
VU00		11	12	1	12
AA00		7	39	0.5	19.5
AA00		8	39	0.5	19.5
AA00		11	39	1	39
AA00	22	9		0.5	11
VU00	110	9		0.5	55

Re: Calculate Volume

upaliwije — Tue, 03 Jan 2017 16:49:38 GMT

Can some one pls help me to solve my issue