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



      Our Product Code