The Dim_Calendar represents the Calendar of the Year
The Dim_Players represents the a team player statistics.
The fact table gives me the total goals of each player in a Team.
I want to have a bar chart to show us the evolution of goals of each player.
This part is easy and could already implement. Except that I'm not getting a point :
If you repair the Player 1 ( ID_PLayer = 1) did not score on 01/03/2015 , but he continues with three goals on league (scored on day 01/01/2015 ) , however the fact table only contains the dates where the player scored goals. So, the chart on Qlikview for the player 1 only returns the following dates:
But I want to create intelligent enough in chart to realize this goals: even though the player has not marked in that date he continues with the same previous goals. So with this data mart the chart should have for the player 1: