Assistance Needed: Resolving Duplicate Sales Data (Double Counting) in Qlik Sense Reports
Hello Qlik Community,
I'm encountering an issue with duplicated sales data (double counting) in our reports within Qlik Sense. For certain dates, the sales values appear doubled, even though our ETL database shows accurate, non-duplicated entries. We've tried filtering out these dates and reloading the QVD files, but the double counting persists in the reports.
For example, on August 16, the actual sales amount in the source data is 1000, but in Qlik Sense, it shows as 2000, effectively doubling the correct value.
Has anyone experienced a similar issue? If so, what steps did you take to resolve it? Any insights or troubleshooting tips would be greatly appreciated!
Hi! The issue of double-counted sales data in Qlik Sense reports can often arise from specific factors in your data model or script configuration.
Did u inspect your data model in Qlik Sense to ensure that you do not have unintentional joins or circular references between tables?
Maybe, try to look for join statements or concatenations that might inadvertently duplicate rows. Pay attention to any Left Join, Outer Join, or Concatenate operations in your script.
As a solution u can replace Join with ApplyMap() where possible, or ensure that keys are unique before joining.
Please note the forum you have posted to is for the Data Integration product Enterprise Manager, used for managing multiple Replicate/Compose/Catalog servers. To reach your target audience, please consider posting your question here: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense
