4 Replies Latest reply: Nov 14, 2017 8:26 AM by Or Shoham RSS

    Percentage match of the same field in two records

    Scott Wisker

      Does QlikView have a function that can compare the values in fields and return a percentage match?

       

      For example:

      Row    Name           City           State     Zip  

      1      ABC Company    Walla Walla    WA        99362  

      2      ABC Co         Walla Walla    WA        99362 

      3      The ABC Comp   Walla Walla    WA        99362

      4      Dave           Indianapolis   IN        46060

      5      ABC Comp       Walla Walla    WA        99362

       

      Rows 1, 2, 3, & 5 are most likely the same company while row 4 is not.