Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
snavas
Contributor
Contributor

report collects the data of a month as the sum of the rest of months

Hello, I hope to express myself well to show you my problem.
I have a report that collects sales for the years 2021, 2020, 2019, 2018 and 2017 but for 2020 filtering by months, the December sum is equal to the sum from January to November.
Is it a common mistake? I have checked the script many times and I do not see any errors, besides that for the rest of the years the data comes out fine.

Thanks for your help.

4 Replies
Or
MVP
MVP

This sounds more like an issue with your underlying data than anything to do with Qlik, but if you provide a more specific formula / example app, perhaps it would be possible to investigate.

snavas
Contributor
Contributor
Author

the formula is similar to this:

---

Sales:

LOAD [SalesTotal]

Sales2020:

LOAD 

[SalesTotal] as [SalesTotal20]

Resident Sales where [DateYear]=2020;

----

for the rest of the years it is the same formula.

thanks for your help

 

Or
MVP
MVP

There's nothing about this formula that suggests it would return incorrect values, so I would check the underlying data.

snavas
Contributor
Contributor
Author

Yes, the formula worked correctly for the other years.

I´ ll keep looking for the error, thank you very much.