Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Conditional Formatting to Highlight Dates older than x Days with a status of y

Hello all,

I would like to use some sort of Conditional Formatting to identify certain rows of data older than 30 days.

I have a Project Created Date field in MM/DD/YYYY, where I want to use conditional formatting to identify Projects that are older than a 30 days, where their status is not A, B, C or D.

The goal of this is to identify the above, but not include for projects that have moved onto a status that this information is no longer important.

Thank you in advance for any assistance.

2 Replies
vgutkovsky
Honored Contributor II

Re: Conditional Formatting to Highlight Dates older than x Days with a status of y

HI, Myles. You can simply press the + sign next to your dimensions and/or expressions to expand them. Then select Background Color and create whatever background color expression you like. For instance, you could say:

if(today()-[Project Created Date]>30 and not match(Status,'A','B','C','D'),lightred())

Regards,

Vlad

trdandamudi
Honored Contributor

Re: Conditional Formatting to Highlight Dates older than x Days with a status of y

I have taken Vlad expression and created a sample app for you. In this sample you can see the highlight only for one row or the entire row. Hope this helps....

Highlight_Rows.jpg

Community Browser