topic Re: Set analysis question in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/1276274#M400831 <HTML><HEAD></HEAD><BODY><P>Those means that you are just ignoring any direct selection made in those fields for this expression. I would also remove the id statement and make this the expression:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count({&lt;[TYPE],[ REASON],[GRP], JOB <SPAN style="color: #ff0000;">-</SPAN>= {'DIRECT'}&gt;} EMPNUM)/2</STRONG></SPAN></P><P></P><P>Note the red negative sign in front of the equal sign after JOB field....</P></BODY></HTML> Wed, 01 Feb 2017 18:33:42 GMT sunny_talwar 2017-02-01T18:33:42Z Set analysis question https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/1276273#M400830 <HTML><HEAD></HEAD><BODY><P>(count({&lt; [TYPE],[ REASON],[GRP] = &gt;} (if([JOB ]&lt;&gt; 'DIRECT', EMPNUM))))/2</P><P></P><P>I am trying to understand what does <SPAN style="font-size: 13.3333px;">{&lt; [TYPE],[ REASON],[GRP] = &gt;}</SPAN> part mean in above expression. Is it used for counting distinct of all 3 combination? no value after = means?</P></BODY></HTML> Wed, 01 Feb 2017 18:31:06 GMT https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/1276273#M400830 rdsuperlike 2017-02-01T18:31:06Z Re: Set analysis question https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/1276274#M400831 <HTML><HEAD></HEAD><BODY><P>Those means that you are just ignoring any direct selection made in those fields for this expression. I would also remove the id statement and make this the expression:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Count({&lt;[TYPE],[ REASON],[GRP], JOB <SPAN style="color: #ff0000;">-</SPAN>= {'DIRECT'}&gt;} EMPNUM)/2</STRONG></SPAN></P><P></P><P>Note the red negative sign in front of the equal sign after JOB field....</P></BODY></HTML> Wed, 01 Feb 2017 18:33:42 GMT https://community.qlik.com/t5/QlikView/Set-analysis-question/m-p/1276274#M400831 sunny_talwar 2017-02-01T18:33:42Z