topic Re: SET ANALYSIS +FUNCTION in QlikView https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828264#M291617 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG>SUM({&lt;EMP_ID = {"$(=MinString(EMP_ID))"}&gt;}Daily_Capacity)</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;">Hope this will helps u.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG>Regards,</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG>Mohammad<BR /></STRONG></SPAN></P></BODY></HTML> Tue, 16 Jun 2015 06:29:15 GMT mohammadkhatimi 2015-06-16T06:29:15Z SET ANALYSIS +FUNCTION https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828262#M291615 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>i have a problem with set analysis</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">SUM</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">EMP_ID</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"=MinString(EMP_ID)"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">Daily_Capacity</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">whats wrong?</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">adi</SPAN></P></BODY></HTML> Tue, 16 Jun 2015 06:24:01 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828262#M291615 adiarnon 2015-06-16T06:24:01Z Re: SET ANALYSIS +FUNCTION https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828263#M291616 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 8pt; line-height: 1.5em;">SUM({&lt;EMP_ID = {"$(=MinString(EMP_ID))"}&gt;}Daily_Capacity)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 8pt; line-height: 1.5em;"><BR /></SPAN></P><P>or</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;">SUM({&lt;EMP_ID = {"=$(=MinString(EMP_ID))"}&gt;}Daily_Capacity)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;">or</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><BR /></SPAN></P><P style="font-size: 13.3333330154419px;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 8pt;">SUM({&lt;EMP_ID = {'$(=MinString(EMP_ID))'}&gt;}Daily_Capacity)</SPAN></P></BODY></HTML> Tue, 16 Jun 2015 06:26:03 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828263#M291616 MK_QSL 2015-06-16T06:26:03Z Re: SET ANALYSIS +FUNCTION https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828264#M291617 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG>SUM({&lt;EMP_ID = {"$(=MinString(EMP_ID))"}&gt;}Daily_Capacity)</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;">Hope this will helps u.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG><BR /></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG>Regards,</STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.6666669845581px;"><STRONG>Mohammad<BR /></STRONG></SPAN></P></BODY></HTML> Tue, 16 Jun 2015 06:29:15 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828264#M291617 mohammadkhatimi 2015-06-16T06:29:15Z Re: SET ANALYSIS +FUNCTION https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828265#M291618 <HTML><HEAD></HEAD><BODY><P>Try changing it to this</P><P>SUM({&lt;EMP_ID = {"(=MINSTRING(EMP_ID))"}&gt;}DAily_capacity)</P></BODY></HTML> Tue, 16 Jun 2015 06:32:49 GMT https://community.qlik.com/t5/QlikView/SET-ANALYSIS-FUNCTION/m-p/828265#M291618 2015-06-16T06:32:49Z