How to Text color expression when value low from prev value ?

[yanivvl0]

Hi everybody ,

i have table with projects , each project can have some steps (and some step_b)  , and for each step can be a date or not (null).

i need to paint in red a date of project step if its value lower than any prev  (existing) date at one of the prev steps in a project ,

something like this :

[akshaye_c_navale]

Hey ,

Try Above and Below function

[antoniotiman]

Hi yaniv,

may be like this in Text Color

If(Not IsNull(Date),
If(Date < RangeMin(Top(Date,1,RowNo()-1)),Red()))

Regards,

Antonio

[yanivvl0]

hi antoniotiman ,

i tried to implement the expression but no good , i added more info see above ,

the thing is that the order is by step_b and the compre must be in a project dates. THANKS.

[antoniotiman · Accepted solution]

In Script

Temp:
LOAD project,step_b,step,date(step_date) as step_date
FROM
https://community.qlik.com/servlet/JiveServlet/download/1345551-295930/reddate_2.xls
(biff, embedded labels, table is Sheet1$);
LOAD *,If(IsNull(step_date),Peek(Date1),step_date) as Date1
Resident Temp
Order By project,step_b;
Drop Table Temp;

Color Text :

If(Not IsNull(step_date),
If(step_date < Aggr(Above(Date1),project,step_b),Red()))

[yanivvl0]

hi Antonio ,  now its OK - THANKS !!