topic Re: How to Text color expression when value low from prev value ? in QlikView

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

yanivvl0 — Sun, 17 Sep 2017 07:52:39 GMT

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 — Sun, 17 Sep 2017 08:12:16 GMT

Hey ,

Try Above and Below function

antoniotiman — Sun, 17 Sep 2017 08:20:20 GMT

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 — Sun, 17 Sep 2017 11:38:46 GMT

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 — Sun, 17 Sep 2017 18:50:09 GMT

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 — Mon, 18 Sep 2017 11:31:49 GMT

hi Antonio , now its OK - THANKS !!