Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot table operation - color code ----- > (SOS)

Hi,

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

(quarterly data)

I have attached the pivot table, the dimensions, the expression used and the visual cues used.

Thanks in advance!

Untitled.png

Tags (2)