topic Logic for a graph in QlikView

Logic for a graph

amars — Mon, 03 Aug 2009 18:57:06 GMT

Hi all,

I want to create a graph like this

I do have Hire Date & Separation Date for an employee. If the employee is still active the separation date is null. I want to know what the logic should be to create a graph like this.

Thank's in Advance.

Regard's

Amar

Logic for a graph

Mon, 03 Aug 2009 19:52:28 GMT

Hi Amar,

I hope the attached application put you in the right direction (use of IntervalMatch).

Good luck!

Rainer

Logic for a graph

amars — Mon, 03 Aug 2009 20:20:06 GMT

Thank's Rainer.

I was thinking about Interval match only but was not able to identify how to put it for dates. This example will help.

Thank's again.

Regard's

Amar