topic Re: MS Project style Team Planner view in QlikView

MS Project style Team Planner view

Thu, 08 Mar 2012 04:37:04 GMT

Has anyone implemented a Team Planner view in QlikView?

This is similar to a Gantt chart, but displays events by resource. Please see the attached spreadsheet as an example.

This is basically the same as requested in this thread: http://community.qlik.com/thread/40676

Re: MS Project style Team Planner view

perumal_41 — Thu, 08 Mar 2012 06:20:51 GMT

Hi,

I attached one Application .please Find Out .i thing Useful for u

Regards

Perumal A

Re: MS Project style Team Planner view

Thu, 08 Mar 2012 22:23:51 GMT

Hi Perumal,

Your example is a Gantt chart, with one activity on each line. The requirement we need to fullfill is to have one line per resource, displaying all activities involving that resource.

Please see the spreadsheet I attached to my original post.

Regards,

Michael

MS Project style Team Planner view

swuehl — Thu, 08 Mar 2012 22:31:39 GMT

Maybe John's solution posted here

http://community.qlik.com/message/89123

gives you a start off.

Hope this helps,

Stefan

Re: MS Project style Team Planner view

perumal_41 — Fri, 09 Mar 2012 04:06:52 GMT

Hi,

I attached one Application .please Find Out .i thing Useful for u

Regards

Perumal A

Re: MS Project style Team Planner view

swuehl — Fri, 09 Mar 2012 14:03:10 GMT

Michael,

this is a nice challenge, so I spent some more time on elaborating something out of John's idea.

My current result looks like:

I struggled a bit with the way how QlikView handles stacked bar charts, but finally I think this looks quite nice.

Please find attached my sample app. The script will automatically calculate the timeintervals with 'NoOp' - no operation - and create the records needed to get a correctly stacked bar chart.

Have fun (and if you struggle, too, just give me a note),

Stefan

MS Project style Team Planner view

Tue, 01 May 2012 06:11:08 GMT

Thanks Stefan,

This looks like it might fit our purpose. The idea of filling in the gaps with NoOp events is the key.

I still have a bit of work to get the time access working properly. I am working with years of data with granuality at seconds.

Michael