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

How to highlight the date comparing to the previous date

Hi all!

Can you help me in my question:

I've got a pivot table that is representing the planned date and the fact date:

DeviceA1Operationfact1234


plan
25.01.201201.03.2012
26.01.201204.03.2012
20.01.201228.02.2012
05.03.2012

I want to highlight in black when

plan date<  current date & fact date is missing

and in blue

plan date<  current date&  fact date<=plan date

Please help.

0 Replies