topic Re: Last used date of a doc-Call in QlikView

Last used date of a doc-Call

kris_vliegen — Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I would like to see if there are doc-call that are not used for a period.

I would like to create a table with the dashboard, user and the last used date of the doc-call.

In the management-console I can see the data (see picture) but if I have to do this for all the dashboards it's taking a lot of time. Where is this date stored?

Re: Last used date of a doc-Call

Sonja_Bauernfeind — Wed, 06 May 2020 12:32:41 GMT

Hello Kris!

You could check out this article: Reading PGO contents and CAL assignments / PGO to XML (kb 000002773) to get you started on how to find CAL usage data.

Basically: The CAL usage data is stored in the CALData.pgo file. You can flip a switch in the QlikView Server settings to print that .pgo file into .XML format. Then you can read (read only) that data and, for example, let a QlikView document read it for easier parsing.

That should give you what you need.

/Sonja

Re: Last used date of a doc-Call

kris_vliegen — Wed, 06 May 2020 12:49:44 GMT

Hi Sonja,

thank you for the reaction. But in the url you attached in your post is mentioned that the "lastused" is encrypted.

So I can not use this way of working.

Re: Last used date of a doc-Call

Sonja_Bauernfeind — Wed, 06 May 2020 13:16:54 GMT

That's true, it'll need a bit more work than that.

Based on the names you can pull from this you can work with session information from other logs to see when the user has last logged in - but regardless it'd require more effort to piece the information together. We don't have a solution for this right out of the box as is.

Alternatively, you could use the APIs. A little digging turned up https://community.qlik.com/t5/QlikView-Documents/QlikView-Management-API-2-Export-Add-Delete-Document-CALs/ta-p/1491243 as an example, which mentions fetching the last used data as well.

Re: Last used date of a doc-Call

Brett_Bleess — Thu, 28 May 2020 17:43:34 GMT

Just wanted to leave a note regarding the product terms and removing Doc CALs from users, refer to Section 3 C Identified Users for information regarding when you can remove Users from Named/Doc CALs, just want to be sure you understand the licensing here too.

QlikView Product Terms

Basically, the two conditions allowed are termination or user changes roles and no longer has use of the product, there is no allowance for last used timestamp removal.

Regards,
Brett