I am trying to link yearly targets to the main data set in QlikView. The issue is that - In the 1st picture, you can see that the sum of target for Name=A for 2018 is 6. However, in the main data set (picture 2) there is no Code for Plant =A & Group = S, M. Hence, the respective targets are not considered in QlikView.
I found 2 solutions on community:
1. Concatenate : This doesn't work because the actual date is connected to the calendar, whereas the targets are on yearly basis
2. Add Dummy data: It is not possible for me to add dummy data based on missing Codes because it is dynamic
Any other idea how I can make this work? Attaching a Sample QVW.