topic Horizontal bar chart - Gantt with 2 dimensions in QlikView

Horizontal bar chart - Gantt with 2 dimensions

Wed, 14 Dec 2011 14:04:17 GMT

Hi all,

I am working on a project with QlikView 11 and am facing some difficulties trying to make a chart like the one in the Excel spreadsheet attached.

What I would like to do is a kind of Gantt chart that would show holiday periods for each user over time.

The project I am working on is in desktop mode. For certain reasons, I cannot use the "WebView" mode of QV, so I cannot use the Gantt extension.

In the spreadsheet, I put a set of data that represents my problem.

As you can see, each person can have different periods to be displayed on the graph (2 for P1, 2 for P2, 3 for P3 and 1 for P4).

When I try to use a horizontal bar chart and playing with the "Bar Offset", I can acheive something close to that, but I cannot have the different occurences (holiday periods) of a perons on the same row (with a Gantt, you will have a row for each ID in my table as Person would be the first dimension and ID the second, if I am correct).

Do you please have any idea on how to reproduce my example wihout using the "WebView" mode of QV?

I have found some posts on this forum regarding Gantt charts but none that do what I would like to do.

Thank you very much,

Cheers,

Anthony

Horizontal bar chart - Gantt with 2 dimensions

Wed, 08 Feb 2012 21:38:22 GMT

Have you had any help with this?

I am also trying to achieve this, although my clients are still using v10 for now.

Horizontal bar chart - Gantt with 2 dimensions

Thu, 09 Feb 2012 07:48:21 GMT

No help so far...

Re: Horizontal bar chart - Gantt with 2 dimensions

perumal_41 — Thu, 08 Mar 2012 06:21:14 GMT

Hi,

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

Regards

Perumal A

Re: Horizontal bar chart - Gantt with 2 dimensions

Thu, 08 Mar 2012 07:45:21 GMT

Hi,

Thanks for the file.

It is close to what I need. But what is really important is to be able to have several occurences of a task.

If I take you example, we could have P1-1 from 2000 to 2004, then from 2006 to 2010.

That means having several bars on the same row.

Cheers,

Anthony

Horizontal bar chart - Gantt with 2 dimensions

swuehl — Fri, 09 Mar 2012 14:05:07 GMT

I've just uploaded a possible solution here:

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

Hope this helps,

Stefan