Qlik Sense - Advanced Formula Question

[#1]

Good Morning Everyone,

I am currently building an Customer Account Review and I have been asked to build a function that would let me enter / display a competitors product code and then covert that to product code that we sell.

For example, We could have scenarios where it could be a 1 to 1 or a 1 to many matching. Both the Competitor Code and Our Product Codes are in the original data load from my ERP I am just looking to build the logic that would associate the two codes.

Competitor Code
123-ABC

Our Product Code
1234
WE#0992
ABC-001

Thanks

[Gysbert_Wassenaar]

Thank you for sharing your story. I wish you the best of luck with your challenge. Don't hesitate to ask any questions if you run into a problem you don't know how to solve.

Perhaps you'll find these two documents helpful:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling

[#3]

Your answer confuses me... does this mean you can not create a dynamic mapping? from one table to another table?

[sinanozdemir]

I think the problem with your example is that we don't know how this logic will be established.

In your example, I can link "Competitor Code" to 2 different fields in "Our Product Code" ; 1234 & ABC-001. Of course, you can link the tables, but you need to provide us a bit more than your dataset.

Hope this helps.

[Gysbert_Wassenaar]

Since you didn't ask any question I have no idea what you want.

Again, let me point out this document:

• QlikCommunity Tip: How to get answers to your post?