Displaying individual group information

[#1]

Hi All,

I'd like to ask if is possible to display individual data for multiple selections.

For instance if you have a list of groups, individual users in that group, and their personal quantity of apples.

In Qlikview, Is it possible to have a table that lists all the members of a group and their individual # of apples?

Thanks Kindly

[#2]

Hi All,

I've been playing with different formats over the weekend, and I can't seem to get it narrowed down to the display as I described above. Could someone shed some light for me? My biggest problem is that there are so many groups involved and each of the individual members contain a large amount of personal performance data.

Thanks

[pratap6699]

if(numberofapples>300,aggr(sum(numberofapples),team1,aggr(sum(numberofapples),team1)

[awhitfield]

Hi Thomas,

see attached, not sure if the expression is what you want though

Andy