topic Re: Set analysis in QlikView https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1019766#M934472 <HTML><HEAD></HEAD><BODY><P>Can you try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;"><STRONG>Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">{&lt;</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">FiscalYear = {'2016-2017'}</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">&gt;} </SPAN>Aggr(Count(DISTINCT {&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">FiscalYear = {'2016-2017'}</SPAN>&gt;} racApplicationNbr), racCustomerID, racApplication_Date))</STRONG></SPAN></P></BODY></HTML> Wed, 24 Feb 2016 15:20:18 GMT sunny_talwar 2016-02-24T15:20:18Z Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1019765#M934471 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Need set analysis for the below expression,</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">if(FiscalYear='2016-2017',Count(Aggr(Count(DISTINCT racApplicationNbr), racCustomerID, racApplication_Date)))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">Thanks<BR /></SPAN></P></BODY></HTML> Wed, 24 Feb 2016 15:18:26 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1019765#M934471 nareshthavidishetty 2016-02-24T15:18:26Z Re: Set analysis https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1019766#M934472 <HTML><HEAD></HEAD><BODY><P>Can you try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;"><STRONG>Count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">{&lt;</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">FiscalYear = {'2016-2017'}</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">&gt;} </SPAN>Aggr(Count(DISTINCT {&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px; background-color: #f2f2f2;">FiscalYear = {'2016-2017'}</SPAN>&gt;} racApplicationNbr), racCustomerID, racApplication_Date))</STRONG></SPAN></P></BODY></HTML> Wed, 24 Feb 2016 15:20:18 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1019766#M934472 sunny_talwar 2016-02-24T15:20:18Z