Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

no dates when results are missing

Hey,

I have a problem with missing dates in a line chart because no results are matches with them.

Say I have an athlete, but he only has dates linked to him when he has had a result on that date (persons were joined to dates via results, so no result for an athlete on a specific date means that athlete has no record for that date either). So when you make a line chart of his performance the x-axis is missing a lot of dates there (I know you can show them with the continous axis option, but the athlete still has no record for those dates). So f.e. the accumulate option in the expressions tab works incorrectly as well.

F.e. if I want YearMonth on the x-axis, and accumulate over the past year, it will accumulate over the past 12 months where the athlete has results, while it should also take account of months where the athlete has no results.

Is there any way of taking account of the missing dates without having to join person on dates? (that would be waaay too large).

1 Reply
Not applicable
Author

You would need a Master Calendar.  There are a lot of resources on the Community forum that contain the script to create one.