Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - Advanced Formula Question

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

4 Replies
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:


talk is cheap, supply exceeds demand
Not applicable
Author

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

sinanozdemir
Specialist III
Specialist III

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:


talk is cheap, supply exceeds demand