The Power of the Rainbow

[karimeddini_sla]

aka: The Power of Green, White, Gray, Blue, Yellow, and Red.

There are obviously numerous articles discussing the benefits of QlikView's color scheme; however, most restrict discussion to Green, Whtie and Gray. Blue, Yellow, and Red are generally mentioned only in articles specific to their usage. Thus, I decided to make a decision table for the rules that determine which color will be used for every QlikView color:

Any Filter	This Filter			This Filter's Values				Comments
Has Selections?	Has Selections?	Is Locked?	Is Showing Alts?	State	Substate		Color
					Selected	Excluded
EITHER	No	CAN'T	EITHER	Possible	N/A	N/A	White	NONE
Yes	No	CAN'T	EITHER	Excluded	N/A	EITHER	Gray	NONE
Yes	Yes	No	EITHER	Selected	Or/And	N/A	Green	If any newly-selected values were Gray, the selected values in all unlocked filters that are responsible for (or, contribute to) excluding the formerly-Gray selected values become Gray. This assumes the intention is to change selections, since otherwise the selections yield no data.
Yes	Yes	Yes	EITHER	Selected	Or/And	N/A	Blue	The selected values of a locked filter cannot change and do not visually indicate the logic mode (OR/AND).
Yes	Yes	EITHER	EITHER	Selected	Not	N/A	Red	Only available in AND mode.
Yes	Yes	EITHER	No	Excluded	N/A	EITHER	Gray	NONE
Yes	Yes	EITHER	Yes	Excluded	N/A	Possible	Yellow	This reduces the process of switching selections within an unlocked filter from 2 steps to 1 step. Quick Intelligence: The Power of Yellow
Yes	Yes	EITHER	Yes	Excluded	N/A	Excluded	Gray	NONE