how to create conditions (alert) in webi report based on sysdate

[rameshparchuri5]

Hi All,

in my webi report (4.1) i have one data base column (expired date).

my question is if expired data in 1 week based on sysdate should be highlighted in one color ,if expired in 2 week ( like sysdate to 14 days)should be highlighted in other color like (BETWEEN sysdate+7 and sysdate+14) . so how to write the alert in report.

Example : below bold text To Expire In next 1 Week and non-bold dates To Expire In next 2 Weeks (based on system date)

Expiry Date (DD-MM-YYYY)
11/3/2019
10/3/2019
12/3/2019
11/3/2019
12/3/2019
14/3/2019
14/3/2019
9/3/2019
15/3/2019
15/3/2019
16/3/2019
9/3/2019
17/3/2019
7/3/2019
18/3/2019
7/3/2019

please help on this .

Thanks,

Ramesh

[mhmohammed]

Hi Ramesh,

Create a Expiring in N Weeks flag variable as below and create a Conditional Formatting using the new variable

=If([Expiry Date] between (Currentdate();RelativeDate(CurrentDate();1;WeekPeriod))) Then 1
ElseIf([Expiry Date] between (RelativeDate(RelativeDate(Currentdate();1;WeekPeriod);1);RelativeDate(CurrentDate();2;WeekPeriod))) Then 2

For Conditional Formatting, follow the below video, what you have to do will be a bit different though. Instead of selecting Sales Revenue less than 10000, you'll need to do Expiring in N Weeks flag = 1, then format as you want, and for 2 week, click on the Green + as shown in video to add another condition.

https://www.youtube.com/watch?v=IOjpbZ3xqz4&feature=youtu.be

Thanks,
Mahboob Mohammed

[rameshparchuri5]

Thanks Mahboob for reply . i have follow same format for different flow .we create 3 variable applied filter . it's working ..

=If (( [Li Validtodate]) Between([sysdate];[RelativeDate +7]))Then 1 Else 0 ....similar 14 and 21 ...

thank for help

Thanks,

Ramesh