Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Dynamically Applying Consultant-Team Map

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

Tags (1)
3 Replies
Not applicable

Re: Dynamically Applying Consultant-Team Map

You should explore IntervalMatch. Have a look at this.

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

Not applicable

Re: Dynamically Applying Consultant-Team Map

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

Not applicable

Re: Dynamically Applying Consultant-Team Map

Use Extend Interval Match function

Community Browser