It summarizes our consulting experience with Qlik and it is targeted to upskill you in Qlik Sense with several practical examples, including building two extensions step-by-step.
1. QlikView Developers transitioning to Qlik Sense (inc. Introduction to Web Development)
2. Qlik Sense Beginners wishing to deepen their knowledge
3. Web Developers who want a better fundamental understanding of the Qlik Engine.
Qlik Sense Self-service project implementations, Extension development, Mashup development, Qlik Scripting, Advanced Expressions, Introduction to the Qlik API, Web Development Fundamentals, Security Rules, Qlik Cloud & more.
Once our Configurable ODBC connection in DSC is setup, we are ready to start assigning CALs to our documents.
First let’s take a look at the users coming from the DB. Go to QMC –> Users –> User Management. Click on the “Search in” drop down list. You should be able to see the ODBC connection we created. Then look for a user or type “*” in the search box to bring all users.
After having created our Entity and Group views, it is time to setup the Directory Service Connector in QMC.
Basically, Directory Service Connector keeps track of the users and it is needed for other management tasks that involve users, such as licence assignment.
In my example, we have all our users in a database. In order for Qlikview to access these users, we must setup a Configurable ODBC connection.
This series of posts are intended to help you integrate Single Sign On using an ODBC connection to a database. This database will contain the users used for authorization in Qlikview.
I will not be covering the authentication side of Single Sign On as it’s not related to Qlikview. However, information on how to create webtickets (necessary to implement single sign on) can be found in Qlikview Community.
What is Single Sign-On (SSO)?
Single Sign On is a user authentication process that allows said user to access different systems. By implementing SSO the user only enters one user and password. This will then authenticate the user against different system within an organization.
Implementing Single Sign On in Qlikview
Even if they are not recommended, pie charts are widely used. We might come across a client or user that will not accept alternative visualizations forcing us to use them.
When this is the case, we need to make sure to make pie charts as clear and easy to use and understand as possible. There are some tips and tricks to take into account when using pie charts.
Number of slices
Straight tables are one of the most commonly used objects in Qlik. I would say there are no reports without tables. Even if we try to avoid them, they are always there.
Tables don’t usually present a problem in our reports. However, when we work with big amount of data, tables don’t perform well and we need to start applying filters to make them smaller. No matter how big and dirty tables can get, users still want all of the detailed data in a table. No filters, no shortcuts. All of it.
This presents a big problem from Read More…