The Power of the Rainbow

karimeddini_sla — Tue, 07 Apr 2015 15:54:02 GMT

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
Has Selections?	Has Selections?	Is Locked?	Is Showing Alts?	State	Selected	Excluded	Color
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

topic The Power of the Rainbow in QlikView

The Power of the Rainbow