Average data

Mon, 17 Oct 2011 20:28:12 GMT

Hi there,

I need to create a table with the "best Racers"

i have the next details:

user name, full name, event raced in, type of event, place, race course, gender and some other things.

i would like to make a table with the "best racers" and with the "worst racers"

for that - i would like to do an average on the PLACE the member got to on each competition and than show the top 5, for each competition and in GENERALL in all competitions. as well as the worst competitors.

Thanks.

Re: Average data

Tue, 18 Oct 2011 13:27:47 GMT

Hi,

You can use the rank() function.

Succes!

topic Average data in QlikView

Average data

Re: Average data