Dynamically Applying Consultant-Team Map

[#1]

Hi:

We have a Lookup table for assigning teams to different consultants.

But the consultants could change teams. If we simply change the team name in the look up table, historical data will move to the new team with the consultant and we don't want that. We want the historical data is still link to the same consultant with his old team.

How can I achieve this with minimum maintenance?

Thank you very much.

PC

[#2]

You should explore IntervalMatch. Have a look at this.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch

[#3]

Hi Ramkumar:

Thank you very much for your reply.

I found this post which I think is very good.

Qlik Tips: Dynamic ApplyMap

They called it dynamic applymap. Basically a set of maps are loaded in a loop and then the maps are applied later base on value of another field.

Thank you

PC

[#4]

Use Extend Interval Match function