topic Gantt - Vertical line marking current date in QlikView

Gantt - Vertical line marking current date

Tue, 18 Jan 2011 23:32:22 GMT

Hello,

I'm working on creating a basic gantt chart, which I've succeeded on thanks to these forums.

The horizontal bar is broken down by %complete in red and %remaining in green.

The yellow line is added in with paint and what I'm trying to get QlikView to do. I'd like to create a vertical line for todays date.

The closest I could come is putting in another expression for todays date and making it an average trend line which comes out close, if it were possible to suppress the horizontal portions.

Any suggestions on how to get the desired effect?

Thanks,

-Ken

Gantt - Vertical line marking current date

rwunderlich — Wed, 19 Jan 2011 00:33:31 GMT

Have you tried a Reference Line with the expression =today()?

-Rob

Gantt - Vertical line marking current date

Wed, 19 Jan 2011 00:50:07 GMT

I have not, and that will solve my problem perfectly. Thanks!

Still pretty new to QlikView and working my way through all of the options.

Gantt - Vertical line marking current date

rwunderlich — Wed, 19 Jan 2011 05:15:49 GMT

Glad it worked for you. Thanks for marking the answer verified and welcome to Qlikview.

-Rob