topic Re: Dynamically Applying Consultant-Team Map in QlikView

Dynamically Applying Consultant-Team Map

Tue, 22 Jul 2014 01:27:02 GMT

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.

Re: Dynamically Applying Consultant-Team Map

Tue, 22 Jul 2014 01:39:38 GMT

You should explore IntervalMatch. Have a look at this.

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

Re: Dynamically Applying Consultant-Team Map

Tue, 22 Jul 2014 05:41:44 GMT

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

Re: Dynamically Applying Consultant-Team Map

Tue, 22 Jul 2014 18:07:43 GMT

Use Extend Interval Match function