How to Make QlikView Ignore Case Sensitivity of Data?
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.
Thank you so much in advance for anyone who can give me even a small clue of how to do so.
thank you for your reply, Facundo de la cal it helps as the interim solution but in the long run, if I have hundred tables from multiple data sources, this approach is not convenient at all. It's a time consuming task on the unnecessary job, in my opinion anyway, thanks again for your reply
hi Jonathan Dienst, thank you for your reply Yes, it helps as the interim solution but i'm looking for the long run solution, to handle my multiple data sources which I never know in what format they will come. Thanks again anyway