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

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

Fri, 15 Jul 2016 20:03:03 GMT

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.

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

vgutkovsky — Fri, 15 Jul 2016 20:55:21 GMT

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

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

trdandamudi — Fri, 15 Jul 2016 21:15:14 GMT

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....