Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
matt_crowther
Specialist
Specialist

Show Most Common User / FileName From Each Day

Hopefully this will be a fairly straight forward one:

I'm looking at the QVS Log files to do a little monitoring of daily Server usage and want to create the following straight table:

Simply; 'Date' as the Dimension (so 1 line per day) and then to display the most commonly opened .qvw and most active user for that day. It's fairly straight forward to display the number of times the most commonly opened .qvw was opened or the number of Sessions the most active User ran (via aggr()) but getting the actual name is proving difficult.

I've also come across several other areas where this could be of great use and I'm sure I'm not the first to need it so I hope there's a swift solution that I'm missing.

Many thanks,

Matt

1 Reply
Miguel_Angel_Baeyens

Hello Matt,

If you enable your sessions log, you will find that the resulting document has a Timestamp field and a Document field you can use for your chart and seem to be easily loadable into your model.

I'll get back with an example if I find time to develop it.

In regards to get only the name of the field something like

=Mid(Document, index(Document, '\', -1) +1, Len(Document))


should work.

Regards.