topic Re: Conditional Format if one date greater than one month in QlikView

Conditional Format if one date greater than one month

kfahri342 — Fri, 17 Nov 2017 10:20:36 GMT

Hi,

I have 2 columns.

1) DATE BASE

2) DATE CURRENT

What expression would I need to use to ensure, that if DATE CURRENT is 1 month greater than Date BASE the cell turns RED.

I am currently using a straight table.

Many Thanks

Kozan

antoniotiman — Fri, 17 Nov 2017 10:45:48 GMT

May be

If([DATE CURRENT] > AddMonths([DATE BASE],1),Red())

Anil_Babu_Samineni — Fri, 17 Nov 2017 10:47:39 GMT

Perhaps this?

If([DATE CURRENT] > AddMonths([DATE BASE],1),RGB(255,1,500))

kfahri342 — Fri, 17 Nov 2017 11:01:17 GMT

Thanks both, it works. Except that it is >= AddMonths