Skip to main content

Support Updates

The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
Jamie_Gregory
Community Manager
Community Manager

Hello Qlik Users! 

How can I track the usage of my Tenant over time? How are my entitled users using the Tenant? 

How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements? 

These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! 

Entitlement Analyzer.pngThe Entitlement Analyzer will help answer those questions and more! The app provides insights on: 

  • Entitlement usage overview across the Tenant 
  • Analyzer Capacity – Detailed usage data and a predication if you have enough 
  • Understand how users are using the system and if they have the right Entitlement assigned to them 
  • Understand which Apps are used the most by using the NEW "App consumption overview" sheet
  • And much more! 

 

Analyzer.JPG

 

The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time. 

 A few things to note: 

  • This app is provided as-is and is not supported by Qlik Support. 
  • It is recommended to always use the latest app. 
  • Information is not collected by Qlik when using this app. 

 

The app as well as the configuration guide can be found at the bottom of this post. This app was created internally and will be supported by the developers of the app. They will be following this thread so be sure to post any questions or issues here so they can be addressed. 

Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up-to-date with the latest Qlik Support announcements. Please give this post a like if you found it helpful! 

Kind regards, 

Qlik Digital Support Team 

 

 

Change log:

Oct. 7, 2021: Updated and attached latest QVF file for Entitlement Analyzer. The new version contains details about open events and therefore allows customers to better understand their consumption of the tenant. 

Oct. 20, 2022: Updates to legacy version and new app with OEM features available.

Version

Description

Customer Type

Ongoing Development

Entitlement Analyzer – Current.qvf

If this is the first time installing this application, use this application. This version addresses bug fixes and introduces support for multitenancy. If “upgrading” to this version from an older version of the Entitlement Analyzer, historical data will be lost.

Direct, OEM

Yes – all new bug fixes and features will be addressed in this version and forward.

Entitlement Analyzer – Legacy.qvf

This version addresses bug fixes and is intended to be used by existing Direct customers to upgrade from the old version while keeping their existing history.

Direct

No – this version of the app will be the last version for Direct customers only.

 

 

63 Comments
SDT
Contributor III
Contributor III

@kmn I removed the ; and got a different error

 

The following error occurred:
(Connector error: HTTP protocol error 401 (Unauthorized): Requested resource requires authentication.)
 
The error occurred here:
RestConnectorMasterTable: SQL SELECT "__KEY_root",
388 Views
MartijnWanders
Partner - Contributor III
Partner - Contributor III

Hi,

Maybe this is useful for others user and the developer!

At one customer a get a problem when loading the script with variable: vMinutes

MartijnWanders_1-1650959251843.png

After searching why data was missing in the variable I found this. There is a variable incremental_qvds_available that is returning a 1 or 0. With this a check will be done if a QVD is existing. In my case it was returning 1 and results in missing data.

I put manually a 0 and load the script. No error anymore and put the 1 back in place. Now my dashboard is working.

I don't know why the variable was 1 in the begining. Maybe the Developer knows this instantly or it was a mistake from my side. 

MartijnWanders_2-1650959828000.png

Have a nice day!

 

 

323 Views
amonjaras
Educator-Ambassador
Educator-Ambassador

This app has been very useful. Thanks?

Is it possible to track sheet usage within an app? Can you point us in the right direction for this?

Thanks again.

586 Views
Sonja_Bauernfeind
Digital Support
Digital Support

Hello @amonjaras 

In Qlik Sense on Prem (Enterprise on Windows), you are able to track sheet usage using the governance app. However, in Qlik Cloud, no app like this currently exists.

I would recommend for you to log an idea for an app like this in our ideas section.

All the best,
Sonja 

518 Views
Sorin39
Contributor II
Contributor II

Hello,,

Can you help me with some info. I made all de necessary configurations, and the script has been running for more than 3 hours now. Do you know by any chance if all is in order.

NextURL << RestConnectorMasterTable 1 Lines fetched
Connected
RestConnectorMasterTable << RestConnectorMasterTable 104 Lines fetched
Consumption << RestConnectorMasterTable 5,467,073 Lines fetched
NextURL << RestConnectorMasterTable 1 Lines fetched
Connected
RestConnectorMasterTable << RestConnectorMasterTable 104 Lines fetched
Consumption << RestConnectorMasterTable 5,467,173 Lines fetched
NextURL << RestConnectorMasterTable 1 Lines fetched
Connected
RestConnectorMasterTable << RestConnectorMasterTable 104 Lines fetched
Consumption << RestConnectorMasterTable 5,467,273 Lines fetched
NextURL << RestConnectorMasterTable 1 Lines fetched
Connected

Thx,

Sorin

377 Views
skozawa
Partner - Contributor III
Partner - Contributor III

@Jamie_Gregory 

Thank you for sharing this app.

I have a question.

Can we analyze data of the past few months in Entitlement Analyzer?

We can see data of only this month by default.
I want to load data of not only this month, but also the past few months.

If possible, wolud you like to tell how to load data of the past few months?

Shiho Kozawa

#874635

339 Views
kmn
Employee
Employee

@Sorin39 is it the 1st time you run the script? I assume the qvd files have not been generated.

308 Views
kmn
Employee
Employee

@skozawa you can get older consumption data if you want. You will need to edit the script to do so. There is a reason for this behaviour of the app and I have explained it in one of my previous comments in this thread:

"So there is of course a reason why you cannot see historical data when running the app for the 1st time.

To explain this I would point my finger to the raw data that this app is using in order to produce the metrics:
 1. /licenses/consumption API
 2. /licenses/overview API

Number 1 has your history of how you are consuming your entitlements (licenses). For this data, the history is kept up to a point in the API and continued with the App in terms of QVDs.

Number 2 has your monthly quota, your overall units/minutes of your entitlement. This set of data is a snapshot and no history is kept within the API. The only way it can be built is via the app and incrementally storing the data into a QVD (on a monthly basis).

Now let's go back to your question. Many visualizations compare your consumption (present and past) against the quota you have (number 2). If you don't have historical values for your quota then your consumption cannot be compared correctly. Hence, your timeline starts the moment you run the app.

There is a solution though. If you know that your quota was the same in the past or you know the past quota values you can edit the script and "fake" historical tables for the Overview - do an inline and store them over the existing QVD. 

Again, this is an example app that showcases the APIs behind it. You are free to make your own version"

286 Views
Sorin39
Contributor II
Contributor II

@kmn yes, it is the first time I run it. I have no previous .qvds generated for it.

417 Views
skozawa
Partner - Contributor III
Partner - Contributor III

@kmn 

Thank you for replying.

I understand I need to edit the script and "fake" historical tables of my quota.

I assume that way is the case for that I want to load the data before the time
when running the app for the 1st time.

If I want to load data from the time when running the app for the 1st time
to present, do I need to "fake" historical tables of my quota,too?

For example, I want to do that:

 July 1th  : I runned Entitlement Analyzer for the 1st time.
      I could see data of July.
 August 1th : After reloading the app, I could see data of only August.
      I want to load data of both July and August.

Shiho Kozawa

366 Views