5 Replies Latest reply: Feb 12, 2016 12:28 PM by Marcelo Carahyba RSS

    How to Make QlikView Ignore Case Sensitivity of Data?

    Wannita Veeramontri

      hi all,

       

      Does anyone know how to make QlikView treat data as case insensitive? Because, I would like to join 2 tables (example below) using LOAD JOIN statements. By default, data in these two tables (Country in Table1 and Country in Table2) will not match each other because of case sensitivity in QlikView unless I use Force statement like force ( capitalization | case upper | case lower ) but I want to keep the character case remaining exactly as it is in each table (Capitalized in Table1 and ALL CAPITAL LETTER in Table2 for column Country). So Force statement doesn't help in my case. I also know that there are functions like upper() and lower() which don't help neither if I want to keep the character case. So I think there should be some configuration parameter in QlikView environment to switch on/off to make QlikView treat data either to be case sentive or insensitive.

       

      Table1:

      CountryColumnA
      Egypt1
      China2
      Brazil3
      Thailand4
      Iran5

       

      Table2:

      CountryColumnB
      EGYPTa
      CHINAb
      BRAZILc
      THAILANDd
      IRANe

       

      Thank you so much in advance for anyone who can give me even a small clue of how to do so.

       

      Best regards,