topic Re: Analyzing web logs using Qlikview in QlikView

Analyzing web logs using Qlikview

Fri, 15 Mar 2013 20:37:23 GMT

I have a table that comtains all of the information form the IIS logs in w3c format. This includes date, time, use ip, page and status. I'd like to be able to calculate the number of visitors my site gets. Basically the definition of a visitor is if a request from an IP comes after 30 minutes from the last request from the same IP, it is considered a different visitor.

As I said My table has date, time and IP address so it should be pretty simple to figure out, I just cant figure out how to do it in Qlikview. Any assistance would be greatly appriciated.

Thanks!

Re: Analyzing web logs using Qlikview

Sun, 17 Mar 2013 15:28:24 GMT

Hi,

could you attach sample IIS log file that you need to analyze?

regards

Re: Analyzing web logs using Qlikview

shane_spencer — Fri, 06 Mar 2015 10:04:04 GMT

A bit late I know but for other with the same requirement check out this Document I posted:

http://community.qlik.com/docs/DOC-6699

specifically the QV-IIS_Logs_processing.qvw attachment.