Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Creating Stunning Dashboards with QlikView
  • Table Of Contents Toc
  • Feedback & Rating feedback
Creating Stunning Dashboards with QlikView

Creating Stunning Dashboards with QlikView

By : Villafuerte
2.6 (7)
close
close
Creating Stunning Dashboards with QlikView

Creating Stunning Dashboards with QlikView

2.6 (7)
By: Villafuerte

Overview of this book

QlikView is one of the most powerful analytical tools in the market. Based on an in-memory associative model, it lets users freely navigate through the data, spot trends and make better decisions. This platform is capable of integrating a wide range of data sources like ERP systems, data warehouses or spreadsheets into a single application in order display dashboards with state-of-the-art visualizations. Creating Stunning Dashboards with QlikView is an easy to follow handbook that guides you through the process of creating an effective and engaging dashboard that delivers tangible value to the business. It starts with the identification of the business needs and the definition of the main KPIs, and takes you all the way to the application rollout. Throughout the book, you will learn how to apply some of the best practices in the field of data visualization, create a robust navigation schema, chose the best chart types for each scenario and many other things that will help you create effective dashboards that uncover all the stories behind the data.
Table of Contents (10 chapters)
close
close

Color highlight


QlikView's natural behavior is to zoom in on the data once a selection is made. However, there is a great downside to doing this: you lose some context because the rest of the elements disappear. One of the most popular ways to overcome this phenomenon is to mix color functions with our good old friend—Set Analysis.

Example: NBA standings.

Relevant features: Set Analysis and color highlight.

To create this visualization, you can do the following:

  1. Create a classic bar chart using Team as the dimension and sum(Wins) as the expression.

  2. This trick is based on two parts. First, we must work with the colors so that only the possible teams are highlighted. Then, we must ensure that even though the user selects just a couple of teams, the chart always displays all of them.

  3. Let's move on to the color. Go to the Expressions tab and click on the Expression Expansion icon.

  4. Locate the Color Background parameter and add the following formula:

    =if(match(Team, concat(DISTINCT Team, ',')),RGB(130...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Edit Note

Modal Close icon
Write a note (max 255 characters)
Cancel
Update Note

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY