I need find Top 5 Users Name Tried Accessing blocked URL based on number of hits in bar chart

[baarathi]

This is my data model. I have UserName in Incoming Buffer Table, Hits in IncomingBuffer Table. I want to get top 5 users who have tried accessing the blocked websites based on Number of Hits on that website, StatusOfConnection which gives us the connection is permitted or not.

Another Problem is How to extract Website Name using URL in QlikView?

For Example:

people-pa.clients6.google.com

lh3.ggpht.com

mail.google.com

ogs.google.com

mail.google.com

clients2.google.com

fonts.gstatic.com

play.google.com

accounts.google.com

3.docs.google.com

fonts.gstatic.com

play.google.com

docs.google.com

clients6.google.com

[baarathi]

for example docs.google.com,play.google.com  I want to get google out of these?

[Anil_Babu_Samineni]

One simply funny answer is

TextBetween(fieldName, '.','.')