topic Current Selection vs. Top 1 vs Avg in QlikView

Current Selection vs. Top 1 vs Avg

Fri, 26 Jun 2009 16:00:03 GMT

Hi,

is it possible to create a table chart where I see all of my customers, their volumne of sales vs. the top customer volumne of sales vs. the avg volumne of sales?

Customer Sales Sales Top 1 Avg Sales
1 10.000 30.000 20.000

2 20.000 30.000 20.000

3 30.000 30.000 20.000

Thanks

Current Selection vs. Top 1 vs Avg

Fri, 26 Jun 2009 16:19:56 GMT

Hi,

Check the attached application.

Cheers

- Sridhar

Current Selection vs. Top 1 vs Avg

Fri, 26 Jun 2009 21:56:16 GMT

Hi,

thanks Sridhar,

can I put in max(all aggr(Sum(Sales), Customer)) some "Set Analysis" like <{Customer=}>, so it doesn't matter what's selected?

Thanks

Regards