Discussion board where members can get started with QlikView.
I need to color the concepts in green which have green background for two consecutive columns (Ex: Headlamps)
and need to color the concepts in red which have red color font for two consecutive columns. (Ex: shutter speed, disk partitioning)
IF(Previous(Concept)=Concept, 'NO', 'YES') as NewConcept
This is how a new concept is defined.
Basically I want to study/identify which concepts have sustained over time/ which concepts have died out based on the difference in the counts of those counts.
The data is historic - period 1990
I have attached the pivot table, the dimensions, the expression used and the visual cues used.
Thanks in advance!