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, 200000, 225000
];

Products:
LOAD *,
pick(match("Product", 'Footwear', 'Tyres', 'Mountain
Bikes', 'Road Bikes'), RGB(236,129,0),RGB(250,185,0),
RGB(70,137,164), RGB(141,25,8)) as "Product color"

RESIDENT ProductsTemp;

Drop table ProductsTemp;
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset