I was wondering if there any dashboard/report which we can use to track which dashboards and which sheets on each dashboard are being visited widely. I went through the Audit logs and also tried using the sheet details that I could extract from the Document Analyzer to produce a particular dashboard.
Below is the code to extract details from Document Analyzer qvw:
Set vDocument=C:\Project\QlikView\XYZApp.qvw;
Sheets:
LOAD '$(vDocument)' as DocumentName,
SubField(SheetId, '\', 2) as SheetID,
Title as SheetName
FROM [$(vDocument)] (XmlSimple, Table is [DocumentSummary/Sheet]);
In Table 1 like I mentioned above I get old dashboard details which I don't want anymore. I am not able to make a unique id for both the tables because of that.
Table 1
Audit_Log:
LOAD
//[Server Started],
//Timestamp,
SubField(Document, '\', 4) as DashboardName,
//Type,
User,
// Message
//SubField(Message, 'SH', 2) as Message,
('SH' & SubField(Message, 'SH', 2)) as SheetID
//DashboardName & ' ' & SheetID as PrimaryKey
FROM
(txt, utf8, embedded labels, delimiter is '\t', msq)
where Type = 'Sheet';
Table 2
Set vDocument=C:\DashboardQVW\*.qvw;
Sheets:
LOAD SubField('$(vDocument)', '\', 😎 as DocumentName,
SubField(SheetId, '\', 2) as SheetID,
Title as SheetName
// DocumentName & ' ' & SheetID as PrimaryKey
FROM [$(vDocument)] (XmlSimple, Table is [DocumentSummary/Sheet]);
