Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should explore IntervalMatch. Have a look at this.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch
Hi Ramkumar:
Thank you very much for your reply.
I found this post which I think is very good.
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
Use Extend Interval Match function