Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
fionna51
Creator
Creator

Use set analysis to get own group among all groups

Hi guys,

Please help me write this set analysis, please use the sample testapp I uploaded.

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)

Thanks in advance.

 

fionna51_0-1629989253050.png

fionna51_1-1629989530117.png

 

 

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try this expression in a straight table with entity and group as dimensions: max({<entity,group=p(group)>}rank)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Try this expression in a straight table with entity and group as dimensions: max({<entity,group=p(group)>}rank)


talk is cheap, supply exceeds demand