Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-07-04 07:54 AM

Logs analyze

Hi!

I have multiple servers, and all have logs of what our clients are doing.

I want to transform and analyze these logs with QlikView. There is a lot of data (> 10 000 commands per day).

Someone has already done this ?

Wich solutions ?

Of course, I can use free software

Thanks

x

305 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2012-07-04 08:20 AM

I assume you are not talking about QV Server Log files, there are some prebuilt QV apps that help you in analyzing these logs.

You first need to analyze the logfiles yourself, i.e. try to get the structure of the data (like each action in one line or multiple lines, timestamp first in line yes / no, any key words and / or separators in your data).

Then you probably need to extensively use the QV string functions to separate your log file lines into QV table fields.

Also the subfield() function might be of interest.

If your free software is easy to use and / or you are more familiar using these and this software creates structured data out of your logfiles, you can also use the 3rd party software to parse in your logfiles, then use QV on top of the structured data for data exploration.

Regards,

Stefan

187 Views