Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies