Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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]);
Regards,
Janaki
There´s one application ready for this: QlikView Application: System Monitor v5.1.23
Hi Clever,
The System Monitor doesn't provide the details I am looking for.
This is the chart/table I am looking for
Dashboard Name | User Name | Sheet ID | Sheet Name | Time-stamp |
Can get the Dashboard Name, Sheet ID, Time-stamp and User Details from Audit Logging. Need to map that Sheet ID with the Sheet ID that I will get from the above code and also get the respective sheet name.
Hope I explained in detail.
Regards,
Janaki
Sorry, @rtz have removed the Audit Sheet
Please refer to this doc : https://community.qlikview.com/docs/DOC-4332 QVS Audit Log sheet
Hi Clever,
The QVS Audit Sheet is great but it doesn't provide me with the Sheet Name and Username mapping. It provides me just with the Sheet ID.
Regards,
Janaki
I don´t think Sheet Name is stored into QVS logs, could you check this?
Hi,
you should also take a look at the Governance Dashboard:
QlikView Governance Dashboard 1.0
QlikView Governance Dashboard 1.1 SR1 Available for Download
regards
Marco
Hi Clever,
To get Sheet Name I used the below code:
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]);
I am looking for a way to map these two tables using Document Name & Sheet ID. One which I get from Audit Logs and the other one I get from Individual Dashboards (using the above code).
But I am having some issues.
Regards,
janaki
Hi Marco,
Thanks for the reply but Governance Dashboard doesn't give me the table structure/data that I need.
Regards,
Janaki
Well, you could start with SystemMonitor, add your script and create a link between your table and remaing tables.
So you could add SheetName to that report