Hello Fred, Just wondering if you found a solution to this? We are working on a security Qlik App, where we need to see all the access users have to documents. We want the same summary, all the CALS users have assigned to documents. We can view this on the server management console, but haven't been able to bring it in to a table yet.
I needed the same thing once, and browsing through the community I came across this solution. Sorry, but I can´t find the source now.
You can use the CalData.pgo to create a QV app to show how many DOC Cals are assigned and to which users and apps.
- Stop the QVS service
- In ProgramData\QlikTech\QlikViewServer edit the Settings.ini file
- Below [Settings 7] add: PgoAsXmlAlso=1
- Start the QVS service
- You will find CalData.pgo.xml in your root folder.
- The info is contained in PerDocumentCalData in the XML file.
This is also useful when you "Lose" DOC cals because you rename your .qvw files.