topic Re: I have a chart issue! in QlikView

I have a chart issue!

samvile18 — Thu, 25 Oct 2012 15:15:42 GMT

Afternoon all,

I've attached the Gantt chart I'm trying to create hoping that someone out there will be able to help me solve some issues I'm having!

My Gantt chart will currently only show the data when the style is grouped, I need to be able to show it stacked so each project has the different phases along the same line.

Can someone out there let me know if this is possible please?

Re: I have a chart issue!

samvile18 — Fri, 26 Oct 2012 08:51:02 GMT

**BUMP**

Re: I have a chart issue!

Anonymous — Fri, 26 Oct 2012 08:59:30 GMT

I represent gantt charts using a horizontal bar chart, with date as the primary dimension, project as the secondrary dimension and number of days as the expression.

Each task then the start date set as it's bar offset, which you can get to by expanding the ( + ) symbol alongside the expression.

Jonathan

Re: I have a chart issue!

samvile18 — Fri, 26 Oct 2012 09:38:35 GMT

Hi Jonathan,

The issue I have though is I don't want the different phases to be offset from one another, I need them to show on the same line.

Whenever I try changing the style to stacked everything vanishes.

Re: I have a chart issue!

Anonymous — Fri, 26 Oct 2012 09:53:21 GMT

Could try using a pivot table instead, with the date dimension running along the top, and the expression being an image that displays different coloured blocks for each phase when the day is active, or blank if no activity that day.

Haven't done it before but have been thinking about it.

Re: I have a chart issue!

samvile18 — Fri, 26 Oct 2012 10:13:31 GMT

This is the latest version I have, the chart that is currently blank is the one I'm trying to turn into a stacked Gantt.

I can't help but feel I'm really close to achieving this.

Re: I have a chart issue!

Anonymous — Fri, 26 Oct 2012 10:19:13 GMT

Soorry, I'd not looked at your example (I tend to check this group when I'm doing a reload so can't open other files at that point). Seems you've got the offset working, and your stacked chart looks good too.

Can't see which of the 3 charts in your example are 'blank' though. Is it CH02, 06 or 07 ?

Re: I have a chart issue!

samvile18 — Fri, 26 Oct 2012 10:23:38 GMT

It's CH07 that is completely blank for me, all I can see are the labels for both axes and the legend box. I can't actually see anything in the main part of the graph...can you see data??

Re: I have a chart issue!

samvile18 — Fri, 26 Oct 2012 10:27:35 GMT

Here's a screenprint of what I can see!!

Re: I have a chart issue!

Anonymous — Fri, 26 Oct 2012 10:35:58 GMT

Looks fine by me..... running Desktop v11.00.11282.0 SR1 (64bit)

Re: I have a chart issue!

samvile18 — Fri, 26 Oct 2012 10:46:29 GMT

Oh WOW...why on earth can't I see that on my version?!!!!

I'm running QV10, surely that can't be why?!

Thanks for your help Jonathan

Re: I have a chart issue!

hic — Fri, 26 Oct 2012 12:58:38 GMT

I can also see your graph fine. I have tried it also in QV 10 SR3 and QV 10 SR5 and it looks fine in both. (Looks like the pic Jonathan posted above.)

Try to download the file from this thread to see if there is any difference between the file you look at and the file we look at.

HIC