Check for time Exceeded

[#1]

Hi All,

I need to write a logic for time exceeded.

Let me explain with an example.

Lead Created on Date is 18-Dec-2015 9:30 AM.

If the time exceeds by 1 hour.

Lets say When i check for the data around 18-Dec-2015 11:30 AM. Since time has exceeded more than one hour. It should be highlighted.

How to write condition for the above scenario.

Regards,

Keerthi KS

[Gysbert_Wassenaar · Accepted solution]

Use something like this for the background color definition for the chart expressions and/or chart dimensions: =if( Now() - [Lead Created on Date] > 1/24, lightred() )

This will probably not work, because we have no idea what you're really trying to do and what kind of data you're working with. Please post a small qlikview document that illustrates the problem.