Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IIS Weblog Analysis

Hi,

I'm currently trying to analyse an iis weblog file.
Seems to be quite a lot of filtering stuff. Has anyone of you already experience with this topic?
Any hints?
Thanks

Regards

Aloah

1 Solution

Accepted Solutions
rwunderlich

I have done this. It's possible to read them with QV scrip, but it easier if you preprocess the logs with MS Logparser. Then you don't have to worry about field positions or multiple headings.

-Rob

View solution in original post

3 Replies
rwunderlich

I have done this. It's possible to read them with QV scrip, but it easier if you preprocess the logs with MS Logparser. Then you don't have to worry about field positions or multiple headings.

-Rob

View solution in original post

Not applicable
Author

Here's a link to some info on the MS Logparser about which Rob wrote:

http://qlikviewnotes.blogspot.com/2008/12/extracting-data-using-microsoft.html

felixobes
Contributor III
Contributor III

Within the load script, just use the option "comment is #" and it will not bring you those lines.

Then just use subfield() to separate the data components into useful bits.