Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Qlik Sense Cookbook

You're reading from   Qlik Sense Cookbook Over 80 recipes on data analytics to solve business intelligence challenges

Arrow left icon
Product type Paperback
Published in Aug 2018
Publisher Packt
ISBN-13 9781788997058
Length 334 pages
Edition 2nd Edition
Arrow right icon
Authors (3):
Arrow left icon
Philip Hand Philip Hand
Author Profile Icon Philip Hand
Philip Hand
Neeraj Kharpate Neeraj Kharpate
Author Profile Icon Neeraj Kharpate
Neeraj Kharpate
Pablo Labbe Pablo Labbe
Author Profile Icon Pablo Labbe
Pablo Labbe
Arrow right icon
View More author details
Toc

Table of Contents (11) Chapters Close

Preface 1. Getting Started with the Data FREE CHAPTER 2. Visualizations 3. Scripting 4. Managing Apps and the User Interface 5. Useful Functions 6. Set Analysis 7. Using Extensions in Qlik Sense 8. Advanced Aggregation with AGGR 9. Tips and Tricks 10. Other Books You May Enjoy

Associating persistent colors to field values using the script


The best practices say that a designer should avoid using bar charts with multi-colored bars or avoid having too many colors in any of your chart objects. But, at times, we need to cater to the demands of the organization and take an uncalled for approach to designing. The following recipe explains how to associate a distinct field value with different colors in the Qlik Sense script.

Getting ready

This recipe serves as a good example to demonstrate the use of the pick function in the script. Perform the following steps to get started:

  1. Create a new Qlik Sense application and name it Persistent Colors.
  2. Open the Data load editor.
  3. Load the following script that contains information about the actuals and budget of four products. The script is available for download on the Packt Publishing website:
ProductsTemp:
LOAD * INLINE [
Product, Actuals, Budget
Footwear, 100000, 120000
Tyres, 180000, 150000
Mountain Bikes, 250000, 195000
Road Bikes...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image