topic Re: Color for dates in QlikView

Color for dates

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

Hi,

I have one date field in table

Ex:

03-01-2019

04-01-2019

-------

24-01-2019.

I want display first five dates(03-01-2019 to 07-01-2019) in one color and next two dates (08-01-2019 to 09-01-2019) in one color.

Again next five days(10-01-2019 to 15-01-2019) in one color and next two dates (16-01-2019 to 18-01-2019) in one color.

The above rule for total date field.

Thaks,

Nikil

Jacek — Tue, 22 Jan 2019 11:06:19 GMT

=if( match( Mod(RowNo(),7), 0,6), rgb(255,0,0), rgb(0,0,255) )

lironbaram — Tue, 22 Jan 2019 11:08:44 GMT

you can do it by using weekday for setting a date color

in your example

in the background example of the font example , you'll use

=if(WeekDay(Date)<>2 and weekday(Date)<>3,green(),red())

will do the trick

Nikhith — Tue, 22 Jan 2019 11:42:49 GMT

Hi
Can u give me a Example

Jacek — Tue, 22 Jan 2019 11:46:50 GMT

Nikhith — Tue, 22 Jan 2019 12:19:11 GMT

Thanks Jacek , It's Working
Regards,
Nikil