topic Check for time Exceeded in QlikView

Check for time Exceeded

Fri, 18 Dec 2015 10:24:16 GMT

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

Re: Check for time Exceeded

Gysbert_Wassenaar — Sat, 19 Dec 2015 14:49:34 GMT

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.