I can't suss out the correct form to achieve what I want from the examples I have found by searching, so I hope someone here could help me. I am using Qlik Sense, not View, if that makes a difference.
We collect commission on in a phased manner, and I want to include the month a payment is due on the month consumption occurs. Each month's consumption for a contract can only have one due month, but there may be many months' consumptions due in the same month for a contract, ie there's a one-to-many relationship between ForecastMonth & ContractMonth. I have stripped the full tables down to this in a test app, but I don't see the ForecastDueMonthStart on the ContractMonth table - what am I doing wrong?