QlikView: Quick tip #3 - Show links in straight tables

Sometimes you will be required to add links to redirect users to the original source of data. This usually happens when you are analyzing help desk information, and you need to check the original ticket. Instead of moving to your help desk system and look for the ticket, you can add a link in QlikView that redirects you to the one that you need to verify. In this quick tip, we will show you how to add links in a straight table. Current example has been applied to redirect users to posts in this blog, but the same approach can be used in other scenarios.

QlikView: Quick tip #2 - Fixed colors in charts

Let say that you are building a dashboard to analize data from a helpdesk system, and you have been requested to add a chart that shows the total of open cases by category (low, medium, high, and emergency). You create the chart, and everything looks fine except for the fact that when you start filtering the data you notice that the colors assigned to each category are not always the same (check the image below, if data is filtered to show only January tickets high is in red color, but if February is selected high is displayed in blue). In this quick tip we explain how to avoid this situation, and keep the color assigned to each posible value in a dimension fixed.

QlikView: Quick tip #1 - Show/hide elements using text objects

Sometimes, we have a lot of objects related that we want to keep in the same sheet. Containers can be an option to avoid crowded visualizations. They are easy to use, you can group and hide and display objects, but when it comes to style, you don't have too many options to play with. Instead, we can use text objects along with variables to display or not objects. In this quick tutorial, I explain how to do it.

QlikView: Custom Calendar Generator

The calendar date dimensions is maybe the most common dimension in a data warehouse.  Sometimes calendars are pretty simple and only contain values such as Year, Month, or Date and some additional format variations like Month-Year, or Quarter-Year.  But, other times you could need additional information  such as fiscal year or holidays.  The Custom Calendar Generator is an application that can be used to create QVDs with calendar information. It has been designed to add holidays, and fiscal period.