Solved: Double Counting in Concatenation - Qlik Community

mhmmd_srf · ‎2016-09-19

Hi All,

I have two QVD files. Sales and Sales_New.

Sales:

Date	Sales
1/1/2016	100
1/2/2016	200
1/3/2016	300

Sales_New:

Date	Sales
1/4/2016	400
1/5/2016	500

When I am trying to concatenate using below script, the records from Sales table is double counting.

Sales:

LOAD Date,

Sales

FROM

Sales.qvd

(qvd);

Concatenate

LOAD Date,

Sales

FROM

Sales_New.qvd

(qvd);

If I am using not exists (date). then it is fine. Why the above script showing double counting data? As per my understanding it should not.

Please advise.

Thanks,

Sarif

sunny_talwar · ‎2016-09-20

Like Ruben mentioned above, your Sales_New doesn't just include the new data, it also includes the data from Sales.qvd

This is screenshot while I load data from Sales_New.qvd. Since the first three dates are available in both the qvds, you see them getting loaded twice. When you use Where Not Exists... the first three values don't get added and only the dates which are not in Sales.qvd gets loaded in.

View solution in original post

rbecher · ‎2016-09-19

Can you attach a sample app?

Astrato.io Head of R&D

mhmmd_srf · ‎2016-09-20

Hi,

Ralf.. I am attaching the qvw file.

Thanks,

Sarif

tresesco · ‎2016-09-20

I see all dates are having frequency as 1. Where do you see it doubled? Am I missing something?

mhmmd_srf · ‎2016-09-20

Hi Tresecco and Ralf,

This is updated one. Please check this.

Thanks,

Sarif

rbecher · ‎2016-09-20

Can you attach the QVD files?

Astrato.io Head of R&D

rubenmarin · ‎2016-09-20

Seems that the Sales_New.qvd has data for the same dates previously loaded in Sales.qvd. Can you load only the sales_new.qvd and check the data it contains?

jayaseelan · ‎2016-09-20

Hi,

I have saw your qvw file is fine. there is no double entries.

Thanks,

mhmmd_srf · ‎2016-09-20

no it has double counting. Check frequency..

mhmmd_srf · ‎2016-09-20

no diff dates.. see the screen shot..