topic Re: Assistance Needed: Resolving Duplicate Sales Data (Double Counting) in Qlik Sense Reports in App Development

Assistance Needed: Resolving Duplicate Sales Data (Double Counting) in Qlik Sense Reports

ronel_8989 — Fri, 15 Nov 2024 07:51:15 GMT

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!

Thank you!

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

VBD — Fri, 15 Nov 2024 08:23:36 GMT

Hello,

Did you try to do a "load distinct" in your fact table to see if rows are always duplicate ?

Regards

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

diegozecchini — Fri, 15 Nov 2024 08:30:02 GMT

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.

kind regards,
Diego

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

Dana_Baldwin — Fri, 15 Nov 2024 15:44:22 GMT

Hi @ronel_8989

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

Thanks,

Dana