topic Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting) in Qlik Answers

Duplicate Sales Data in Qlik Sense Reports (Double Counting)

ronel_8989 — Tue, 26 Nov 2024 10:00:02 GMT

Hello Qlik Community,

I’m experiencing an issue with duplicate sales data in Qlik Sense reports. For certain dates, the sales values are doubled, even though the source data in our ETL and QVD files is correct and shows no duplication.

For example:

On October 22, 2024, the actual sales amount should be 1,000, but the Qlik Sense report displays it as 2,000.

Actions Taken:

Verified the ETL database to confirm the data is accurate.
Filtered out problematic dates and reloaded the QVD files.
Replaced the production QVD with the corrected version.

Despite these steps, the issue persists in the reports.

Question:

Has anyone encountered this issue before?
Are there specific settings, expressions, or troubleshooting steps I can try to resolve it?

Any help or guidance would be greatly appreciated!

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

mpc — Tue, 26 Nov 2024 07:37:52 GMT

Hi,

Did you check if your date is a true date or if it's a timestamp ? Then remove the decimal part of it and retry

Regards

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

ronel_8989 — Tue, 26 Nov 2024 09:03:34 GMT

Hi,

Thank you for your response! I’m a bit confused about your suggestion regarding the timestamp. Let me clarify my scenario:

For example, on August 16, 2024, the actual sales should be 1,000. However, in my Qlik Sense report, it shows as 2,000, which is double the correct value.

The Transaction Date field in my data source appears as a full timestamp, like 2024-08-16 12:34:56. Are you suggesting that I need to strip out the time portion (e.g., 12:34:56) and use only the date part (2024-08-16) for aggregation?

If so, how would I implement this properly in my expressions or load script to avoid such duplication?

Thanks in advance for clarifying

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

mpc — Tue, 26 Nov 2024 09:07:37 GMT

Let me explain more deeper, but you've understand it right

Maybe two date have two timestamps, for some reason. So when you select a date, you will see two lines instead of one.

To prevent it, you can use Date(Ceil("Transaction Date")) as Date in script for better performance and maintainability

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

ronel_8989 — Tue, 26 Nov 2024 09:30:43 GMT

I’ll definitely try this suggestion, but what confuses me is why this issue is only occurring now. Considering the large volume of transactions and how long we’ve been using Qlik Sense, it’s surprising that this problem is only appearing for specific dates. So far, I’ve identified four dates where the sales amount is doubled

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

ronel_8989 — Tue, 26 Nov 2024 10:01:52 GMT

I’ve updated the post and attached a file that might help clarify the issue. Thank you so much for your assistance

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

mpc — Tue, 26 Nov 2024 10:27:28 GMT

Thx, can you try to add all your column in the test table please ?

Re: Duplicate Sales Data in Qlik Sense Reports (Double Counting)

ronel_8989 — Wed, 27 Nov 2024 02:46:11 GMT

So these are all the columns currently in the test table