We have web usage stats available from our server but in a very non user friendly way.
I want to use Qlikview to bring it all together to provide reports to the managers.
Basically data is available on user and date specific pages:
which contains the WebPage, LengthOfUse, Bytes in a table
I want to have a table of Users:
Name - Simon Smith, Debbie Jenkins, Jane White etc
Initials - SS, DJ, JW etc
and a table of Dates
And then get QV to loop through the various combinations to create a master table:
UserName, Initials, Date, WebPage, LengthOfUse, Bytes
OK so I've got this far by looking at other discussions:
Set vURLStart = '[http://webstats/daily/';
Set vURLStart1 = '[http://webstats/daily/2013Apr16-2013Apr16';
Set vURLStart2 = '[http://webstats/daily/2013Apr15-2013Apr15';
Set vURLEnd = '.html] (html, ansi, embedded labels, table is @2)';
For Each User in '/group.simon_smith', '/group.debbie_jenkins', '/group.jane_white'
For Each Date in '2013Apr16', '2013Apr15'
'$(Date)' as Date,
'$(User)' as User,
[ACCESSED SITE] as Site,
BYTES as Bytes,
[ELAPSED TIME] as Time
Now to prevent having a very large list of dates I would like Qlikview to reference an Excel spreadsheet
LOAD DATE(@1,'YYYYMMMDD') as Date
FROM C:\WebDatesOnly.xls (biff, explicit labels, table is Sheet1$);
For Each Date in DatesTable (instead of the comma separated list)
But I just can't get this last bit to work
All simple ideas gratefully received.