you need to create a bridge table between the two original tables.The by far simplest way to solve this problem inQlikViewis to use the Interval Match. It is a prefix that can be put in front