I'm trying to create a conditional join, but haven't difficulty setting this up in Qlik Sense.
I need the match between two criterias
Customer ID to Customer ID
Bill date to >= Account owner by month
I need to make sure that the $100 billed in January is linked to the sales person 2, as they were the owner in January and that the $200 gets linked to the sales person 1 as they were the owner in Aug 2017.