Brace yourself - Black Friday is here

[Qlik(o)graphics]

Ready or not - here I come you can hide...

​'The Fugees' song is probably a good theme for one of the most unpredictable days of the year. Are you ready?

black_friday.qvw
File Size:	433 kb
File Type:	qvw

Download File

---

Let's talk tech

Power to the user - dynamic color change
You can dynamically change color of the application.
The final outcome is presented below:

Below is quick guide how to do that:

In Script:
1) Create variables that you going to use as colors:
 
SET  vco_1='RGB(255,0,0)';
SET  vco_2='RGB(179,0,0)';
SET  vco_3='RGB(255,128,0)';
SET  vco_4='RGB(179,89,0)';
SET  vco_5='RGB(0,0,0)';
 
2) Create inline table that will be used a list box:
//OptionsListbox
Option:
 load * inline [
 Option
 Option1
 Option2
 Option3
 Option4
 Option5
 ];
 
3) Another table will be used as colors Matrix:
ColorsMatrix:
 load * Inline [
 Option1,Option2,Option3,Option4,Option5
 '$(vco_1)','$(vco_2)','$(vco_3)','$(vco_4)','$(vco_5)',
 '$(vco_5)','$(vco_4)','$(vco_1)','$(vco_2)','$(vco_3)',
 '$(vco_2)','$(vco_1)','$(vco_5)','$(vco_3)','$(vco_4)',
 '$(vco_4)','$(vco_3)','$(vco_2)','$(vco_5)','$(vco_1)',
 '$(vco_3)','$(vco_5)','$(vco_4)','$(vco_1)','$(vco_2)',
 ];
 
*The number of colors is defined by numbers of variables:
For 3 variables the matrix will be 3x3.
In Front End

1) Create 5 variables that will used as a picker from listbox of “Options”
vco_Opt1 =$(=fieldvalue($(v_Option),1))
vco_Opt2 =$(=fieldvalue($(v_Option),2))  
vco_Opt3 =$(=fieldvalue($(v_Option),3))
vco_Opt4 =$(=fieldvalue($(v_Option),4))
vco_Opt5 =$(=fieldvalue($(v_Option),5))

and another variable that will be used as a lookup to the orphan (Option) table:
=Chr(39)&Option&Chr(39)
 
2) Create an “Option” listbox

​Each time you create an object and you want to use one of the colors option
you need to add one of the color variables to the Calculated field window: