https://community.qlik.com/t5/QlikView/Need-help-to-suggest-about-use-Set-analysis-in-dimension/m-p/1589906#M596434 <P>Try this expression</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">=If(aggr(([Member Status]=1) * (Sum(Sale)&gt;0), [Member ID]), 'Member', 'Non Member')</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 732px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13458i3D4FB64EDA0AFE28/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span>&nbsp;</P> Mon, 10 Jun 2019 09:09:23 GMT Vegar 2019-06-10T09:09:23Z https://community.qlik.com/t5/QlikView/Need-help-to-suggest-about-use-Set-analysis-in-dimension/m-p/1589899#M596433 <P>1. I have raw data as &amp; sample as attach file</P><P>2. Table raw data just show all data</P><P>3. Table 2 Show Member</P><P>4. Table 3 Need help, find active member condition is<BR />&nbsp; &nbsp; &nbsp; 4.1 [Member Status] =1<BR />&nbsp; &nbsp; &nbsp; 4.2 sum(Sale) &gt;0<BR />&nbsp;<BR />If you have any question please let me know.</P> Mon, 10 Jun 2019 08:38:30 GMT https://community.qlik.com/t5/QlikView/Need-help-to-suggest-about-use-Set-analysis-in-dimension/m-p/1589899#M596433 panwipa2528 2019-06-10T08:38:30Z https://community.qlik.com/t5/QlikView/Need-help-to-suggest-about-use-Set-analysis-in-dimension/m-p/1589906#M596434 <P>Try this expression</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">=If(aggr(([Member Status]=1) * (Sum(Sale)&gt;0), [Member ID]), 'Member', 'Non Member')</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 732px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/13458i3D4FB64EDA0AFE28/image-size/large?v=v2&amp;px=999" role="button" title="image.png" alt="image.png" /></span>&nbsp;</P> Mon, 10 Jun 2019 09:09:23 GMT https://community.qlik.com/t5/QlikView/Need-help-to-suggest-about-use-Set-analysis-in-dimension/m-p/1589906#M596434 Vegar 2019-06-10T09:09:23Z