topic Re: Case sensitive problem in Set-Analysis in QlikView https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659519#M240587 <HTML><HEAD></HEAD><BODY><P>Really strange! And a good notice. I never noticed specially this:</P><P><IMG __jive_id="61241" alt="untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61241_untitled.png" style="width: 620px; height: 227px;" /></P></BODY></HTML> Thu, 26 Jun 2014 09:00:58 GMT tresB 2014-06-26T09:00:58Z Case sensitive problem in Set-Analysis https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659518#M240586 <HTML><HEAD></HEAD><BODY><P>Hello everyone,<BR /> i have a question to the logic that is used in Set-Analysis. Set-Analysis is in some cases casesensetive(CS) in some cases caseinsensetive(IS). It looks like a two stage logic, first QV compares with a = and if no data matches he uses the like. But the = is CS and the like is IS. The selection/data-model logic in QV is CS, so it is a problem if i use Set-Analysis to simulate a users selection. Is there a way to use a command like the SQL Collate-Statement, to force the Like-Statement to be CS.<BR /> Please see the attatched file,where you can see the Problem. <BR /> I would be very thankful some good solutions.<BR />Lukas</P></BODY></HTML> Thu, 26 Jun 2014 08:49:16 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659518#M240586 lukaspuschner 2014-06-26T08:49:16Z Re: Case sensitive problem in Set-Analysis https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659519#M240587 <HTML><HEAD></HEAD><BODY><P>Really strange! And a good notice. I never noticed specially this:</P><P><IMG __jive_id="61241" alt="untitled.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/61241_untitled.png" style="width: 620px; height: 227px;" /></P></BODY></HTML> Thu, 26 Jun 2014 09:00:58 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659519#M240587 tresB 2014-06-26T09:00:58Z Re: Case sensitive problem in Set-Analysis https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659520#M240588 <HTML><HEAD></HEAD><BODY><P>I'm afraid I haven't got a solution for you - but that's a very interesting analysis! Thanks.</P></BODY></HTML> Thu, 26 Jun 2014 09:01:37 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659520#M240588 juleshartley 2014-06-26T09:01:37Z Re: Case sensitive problem in Set-Analysis https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659521#M240589 <HTML><HEAD></HEAD><BODY><P>It's a bug (see <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/09/quoteology#comment-17692">here</A>), but I don't know of any workaround.</P></BODY></HTML> Thu, 26 Jun 2014 09:02:04 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659521#M240589 Gysbert_Wassenaar 2014-06-26T09:02:04Z Re: Case sensitive problem in Set-Analysis https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659522#M240590 <HTML><HEAD></HEAD><BODY><P>I can only think of something really horrible like switching out lower case letters for an integer... and then using that in the set analysis. ouch!</P><P><BR /> </P></BODY></HTML> Thu, 26 Jun 2014 09:22:31 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-problem-in-Set-Analysis/m-p/659522#M240590 juleshartley 2014-06-26T09:22:31Z