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:
- Create a new Qlik Sense application and name it Persistent Colors.
- Open the Data load editor.
- 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;