average by subfield excluding selection

Mon, 01 Sep 2014 14:05:58 GMT

Group	Team	Person	Value
A	T	Anne	2
A	T	Ben	2
A	T	Claire	4
A	U	Dave	6
A	U	Ed	2
A	U	Frank	4
B	V	George	6
B	V	Harry	8

Hi Guys,

Could someone help me with a chart expression? The user has a list box for Person so they can select an individual.

When the user selects a person, i need an expression which averages the total of the whole of their team, excluding that selected person.

Essentialy this chart shows the Average for that indivial (expression 1) and wants to compare them against the average for the rest of their Team (expression 2).

In the example above, if a user selected Anne, expression 1 would show "2", expression 2 would show "3" (Ben's "2" + Claire's "4" / by the both of them.

Hopefully his makes sense, please let me know if you need more information.

Thanks,

Re: average by subfield excluding selection

Gysbert_Wassenaar — Mon, 01 Sep 2014 14:09:52 GMT

See attached qvw

Re: average by subfield excluding selection

Tue, 02 Sep 2014 08:02:07 GMT

Hi,

To get your requirement use Set analysis function E()

Use Expression like

Expression1 = Avg(Value)

Expression2 = Aggr(Avg({1}Value),Team)

Regards,

Vivek

topic Re: average by subfield excluding selection in QlikView

average by subfield excluding selection

Re: average by subfield excluding selection

Re: average by subfield excluding selection