QlikView: Nested If Statements

It is best practice to design QlikView apps (or any BI application for that matter) in a way that presents the information in a clear and concise manner, so that users can spend their time and energy on analysis rather than wondering what it is they are actually looking at. Here is an example. I…

Read More

Qlikview: Creating a Master Calendar

When using dashboards, time is almost always an important factor. Users will always be interested in viewing data by time period, and often times comparing data between two time periods. In a typical data warehouse a time dimension is usually present. If there is a situation where a time dimension is not available, then it…

Read More

Qlik Sense: Using Fuzzy Searches

With Qlik Sense, you can now search Records to find data that matches, or kind of matches, a search criteria. This is known as fuzzy searching.  A fuzzy search compares the original searched string to each record and determines its degree of resemblance.  The results of these searches are ordered in degree of resemblance order.…

Read More

QlikView: Using a Trigger to Set a Default Selection

By setting a default selection on a document or sheet, such as year or month, is an easy way to control the initial starting point when a user logs in. Providing defaults is essential as it will help to narrow the view and provide a focused lens to aid the user as they begin their…

Read More

QlikView: Using Alternate States for Comparative Analysis

Alternate states allow users to make different selections on the same dimension, which can be very useful when performing comparative analysis. In the example below will be comparing sales between two countries, and to go a step further we will also be able to compare sales people with one another to get an idea of…

Read More