Archive | Development RSS for this section

Integrating Single Sign On in Qlikview – Part III

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.

Read More…

Integrating Single Sign On in Qlikview – Part II

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.

Read More…

Integrating Single Sign On in Qlikview – Part I

Scenario

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

Read More…

Have a slice

Image 5

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

Read More…

Straight Table Pagination

Example of Straight Table Pagination

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…

Share Bookmarks with Other users

Making a bookmark accessible to other users

Bookmarks can either be  Private or Public.

Private bookmarks are created by users and can only be accessed or used by the creator.
Public bookmarks can be accessed by all users within a specific document.

Using Ajax or IE plugin, bookmarks can be created from the top bar.

Top bar - Adding bookmarks

Top bar – Adding bookmarks

In order to make a bookmark public or accessible to other users, Read More…

Set Analysis Vs. IF()

I still see many people using IF() statements inside expressions.
I have decided to make a simple test with unique values going from 1,000 to 10,000,000 records.
I have created two streight tables. One using IF() and the other one using Set Analysis.

In the first table I used this expression: sum(if(Sales >=10, Sales))
The second table had this other expression: sum({< Sales = {“>=10”} >} Sales)

I then took notes of the calculation time and the memory used. See the charts below showing the results.

Calculation Time

Calculation Time

Read More…