topic Re: color expression for date in QlikView

color expression for date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I need expression for date please, like:

green color = 2 months or above

red color = expired

yellow color = 1 month or less

like the following:

Color Measures

Re: color expression for date

Frank_Hartmann — Mon, 20 Mar 2017 13:22:00 GMT

can u provide sample qvw?

Re: color expression for date

Anonymous — Mon, 20 Mar 2017 14:35:44 GMT

Hi Mr. Frank,

find the attached file please.

Re: color expression for date

vishsaggi — Mon, 20 Mar 2017 15:12:50 GMT

May be this?

Attached.

Re: color expression for date

Anonymous — Tue, 21 Mar 2017 05:50:32 GMT

vishsaggi‌ I can't open the file because I don't have a license, can you please copy & paste the expression here !

Best regards

Re: color expression for date

hemanthaanichet — Tue, 21 Mar 2017 06:29:42 GMT

Go to expression tab

expand the +

background color

Apply the below expression

=IF([Contract Validity] >= Date(AddMonths(Today(),2), 'MM/DD/YYYY'), RGB(0,202,101), IF(Year([Contract Validity]) <Year(Today()), LightRed(), IF([Contract Validity] < Date(AddMonths(Today(),1), 'MM/DD/YYYY'), Yellow())))

Re: color expression for date

vishsaggi — Tue, 21 Mar 2017 13:38:33 GMT

In your expression tab - Background Color, use below:

= IF(Year([Contract Validity]) < Year(Today()), LightRed(),

IF([Contract Validity] >= Date(AddMonths(Today(),2), 'MM/DD/YYYY'), RGB(0,202,101),

IF([Contract Validity] < Date(AddMonths(Today(),1), 'MM/DD/YYYY'), Yellow())))