Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last daily total showing month total

Hi,

I've found an issue in one of my reports where the x axis is the number of each day eg. 1-31 for Oct.  For days 1-30, it shows the total for each day (on average 4.3) however for day 31 it shows the total for the month (eg.700). 

Has anyone ever came across a problem like this before?

Any help is much appreciated..

Thanks in advance

2 Replies
erichshiino
Partner - Master
Partner - Master

Can you check if the day number is correctly associated with the date?

you could create some tables to identify that.

If the total for each day comes from a more detailed table (with invoices, for example), you could check if the correct details are associated with the day 31

hope it helps,

Erich

Anonymous
Not applicable
Author

It would be very helpful if you could attach a sample .qvw file to your question that is illustrating the problem. That way you would likely be provided with a resolution much quicker and more to the point.