I am trying to build a QlikView model to represent our staffing history & projection. I am having a problem representing the case where one table is related to another table in two different ways.
I have Consultants and I have Projects as tables in my QV data model.
A Consultant is assigned to a Project, and also has a Project that they will be working on after their current Project (or maybe they don't, indicating we need to find a next Project for them). How would I build this relationship between the Consultant and the Projects? Both the current Project and next Project come from the same list of Projects.