4 Replies Latest reply: Jun 19, 2015 1:00 PM by Gysbert Wassenaar RSS

    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