Duplicate Sales Data in Qlik Sense Reports (Double Counting)

[ronel_8989]

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:

1. Verified the ETL database to confirm the data is accurate.
2. Filtered out problematic dates and reloaded the QVD files.
3. 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!

[mpc]

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

[ronel_8989]

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

[mpc]

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

[ronel_8989]

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

[ronel_8989]

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

[mpc]

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

[ronel_8989]

So these are all the columns currently in the test table