https://community.qlik.com/t5/QlikView/Use-set-analysis-to-get-own-group-among-all-groups/m-p/1831463#M1214570 <P>Hi guys,</P><P>Please help me write this set analysis, please use the sample testapp I uploaded.</P><P>In this app, entity related to different groups, and they have ranks within own group. What we want to do is if I select any one entity, I want to see ranks for the group related to selected entity. For example if I select COMM2, I should see group A ranks. (select COMM1, 3, and 4, should display same ranks)</P><P>Thanks in advance.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fionna51_0-1629989253050.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60799iED11135AEC4EAA7B/image-size/medium?v=v2&amp;px=400" role="button" title="fionna51_0-1629989253050.png" alt="fionna51_0-1629989253050.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fionna51_1-1629989530117.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60803iDDDF5C661207022D/image-size/medium?v=v2&amp;px=400" role="button" title="fionna51_1-1629989530117.png" alt="fionna51_1-1629989530117.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 26 Aug 2021 14:56:16 GMT fionna51 2021-08-26T14:56:16Z https://community.qlik.com/t5/QlikView/Use-set-analysis-to-get-own-group-among-all-groups/m-p/1831463#M1214570 <P>Hi guys,</P><P>Please help me write this set analysis, please use the sample testapp I uploaded.</P><P>In this app, entity related to different groups, and they have ranks within own group. What we want to do is if I select any one entity, I want to see ranks for the group related to selected entity. For example if I select COMM2, I should see group A ranks. (select COMM1, 3, and 4, should display same ranks)</P><P>Thanks in advance.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fionna51_0-1629989253050.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60799iED11135AEC4EAA7B/image-size/medium?v=v2&amp;px=400" role="button" title="fionna51_0-1629989253050.png" alt="fionna51_0-1629989253050.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fionna51_1-1629989530117.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/60803iDDDF5C661207022D/image-size/medium?v=v2&amp;px=400" role="button" title="fionna51_1-1629989530117.png" alt="fionna51_1-1629989530117.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 26 Aug 2021 14:56:16 GMT https://community.qlik.com/t5/QlikView/Use-set-analysis-to-get-own-group-among-all-groups/m-p/1831463#M1214570 fionna51 2021-08-26T14:56:16Z https://community.qlik.com/t5/QlikView/Use-set-analysis-to-get-own-group-among-all-groups/m-p/1831478#M1214571 <P>Try this expression in a straight table with entity and group as dimensions: max({&lt;entity,group=p(group)&gt;}rank)</P> Thu, 26 Aug 2021 15:14:51 GMT https://community.qlik.com/t5/QlikView/Use-set-analysis-to-get-own-group-among-all-groups/m-p/1831478#M1214571 Gysbert_Wassenaar 2021-08-26T15:14:51Z