2 Replies Latest reply: Nov 14, 2017 1:00 AM by Anil Babu RSS

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

    Baarathi V

      DataModelOfProxyDb2.PNG

      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