topic Re: using upper function in set analysis in QlikView https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/1595564#M443880 <P>Will the double quote fetch both the upper and lower case data and sum it? I don't think it works. Can you explain with more details?</P> Tue, 25 Jun 2019 11:00:14 GMT nagarajupinnibo 2019-06-25T11:00:14Z using upper function in set analysis https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/388263#M144881 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to use upper function in set analysis but I am not able to do this. Can you please guide me how to do this</P><P></P><P>sum({&lt;upper([Leave Type]) = {'SICK'}&gt;} [Hours Left])</P><P></P><P></P><P>The upper function in above expression is not working. Can you please tell me how do we use such functions in set analysis</P><P></P><P>Regards</P><P>Arif</P></BODY></HTML> Mon, 20 May 2013 21:42:53 GMT https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/388263#M144881 2013-05-20T21:42:53Z Re: using upper function in set analysis https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/388264#M144882 <HTML><HEAD></HEAD><BODY><P>May be this</P><P>Sum({&lt;[Leave Type]={"SICK"}&gt;} [Hours Left])</P><P></P><P>Using double quotes will compare both upper and lower case.</P></BODY></HTML> Mon, 20 May 2013 22:09:41 GMT https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/388264#M144882 CELAMBARASAN 2013-05-20T22:09:41Z Re: using upper function in set analysis https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/1595564#M443880 <P>Will the double quote fetch both the upper and lower case data and sum it? I don't think it works. Can you explain with more details?</P> Tue, 25 Jun 2019 11:00:14 GMT https://community.qlik.com/t5/QlikView/using-upper-function-in-set-analysis/m-p/1595564#M443880 nagarajupinnibo 2019-06-25T11:00:14Z