topic Qlikview Gantt chart look a like in QlikView

Qlikview Gantt chart look a like

Wed, 10 Nov 2010 12:21:01 GMT

hi All,

i am trying to make a visual view of the occupation of a operations room.
The chart should look like the Gantt chart but it has hours on X-axis instead of days.
I allready made the view with Reporting Services but in Qlikview it also should be possible (i guess).
In Reporting Services it looks like (a day is selected and the operations on that day are shown):

(this isn't the latest version because i now also show the planned sessions in the same graph but this is the idea..)
The data i have has a start time and end time of an operation, the color depends on the specialist, i want each operation showed in the graph)

With the Gantt chart extension in Qlikview 10 i am not able to get something like above...
With a 'normal' chart i'm not able to get all operations on 1 line (then the chart get's much bigger)

what's the best way to make this in Qlikview?

Thanx for all/any help!

regards,

david

Qlikview Gantt chart look a like

Wed, 10 Nov 2010 13:35:47 GMT

this is what it looks like in qlikview now:

Qlikview Gantt chart look a like

johnw — Thu, 11 Nov 2010 01:23:17 GMT

I don't think this is quite what you need, but it does have different operations on the same line. Might give you some ideas.

Qlikview Gantt chart look a like

Fri, 12 Nov 2010 10:43:14 GMT

Hi John,

thanx for your reply, your version could work but i that case i need a way to autogenerate records between the operations because my current data only containes used time and not the unused time. Do you know a way to do that?

Thanx!

david

Qlikview Gantt chart look a like

Fri, 12 Nov 2010 12:06:16 GMT

hi,

i tried to use to solution you provided and it almost worked...
The only problem is that if i use bar offset some operations are not showed anymore and if i don't use bar offset all operations are without intermediate time (time between operations..)

i'll post my qvd..

thanx.

david

Qlikview Gantt chart look a like

Fri, 12 Nov 2010 12:11:48 GMT

in the file attached i have to graph's who are exactly the same except for bar offset..

can you get this to work? or should i try to get records to fill the gaps in the time between?

Thanx!

david

Qlikview Gantt chart look a like

Fri, 12 Nov 2010 14:51:59 GMT

After some trying my conclusion is that the best solution is to create records of the not operaring time..
my current table is like this:

Begin end spe
8:00 9:13 ORT
9:17 9:59 CHI
10:13 13:15 ORT

It should look like this:

Begin End spe

0:00 8:00 none

8:00 9:12 ORT

9:13 9:16 none

9:17 9:59 CHI

10:00 10:12 none

10:13 13:15 ORT

is this possible?

regards,

david

Qlikview Gantt chart look a like

Fri, 12 Nov 2010 19:37:00 GMT

hi,

i managed to get the records created with the previous function and help of a collegue.
the script i use now is:

OKMergetemp2:

NOCONCATENATE

LOAD

RESIDENT

OKMergetemp

ORDER

BY OKBezettingType ASC, OKBezettingOperatieDatum ASC, OKBezettingOKKamer ASC, OKBezettingBT_OK ASC

;

drop

TABLE

OKMergetemp;

Concatenate

Load

Recno

() as OKBezettingNummer

((OKBezettingOKKamer<>previous(OKBezettingOKKamer) or OKBezettingOperatieDatum <> previous(OKBezettingOperatieDatum) or OKBezettingType <> previous(OKBezettingType

)), '0' ,

((OKBezettingOKKamer=previous(OKBezettingOKKamer) and OKBezettingOperatieDatum = previous(OKBezettingOperatieDatum) and OKBezettingType = previous(OKBezettingType)), previous(OKBezettingET_OK)+0.01,OKBezettingBT_OK)) as OKBezettingBT_OK

OKBezettingOKKamer

OKBezettingOperatieDatum

OKBezettingOperatieJaar

OKBezettingOperatieMaand

OKBezettingOperatieDag

OKBezettingDuur

((OKBezettingOKKamer<>previous(OKBezettingOKKamer) or OKBezettingOperatieDatum <> previous(OKBezettingOperatieDatum) or OKBezettingType <> previous(OKBezettingType)), OKBezettingBT_OK

-0.01 ,

((OKBezettingOKKamer=previous(OKBezettingOKKamer) and OKBezettingOperatieDatum = previous(OKBezettingOperatieDatum) and OKBezettingType = previous(OKBezettingType)), OKBezettingBT_OK-0.01,OKBezettingBT_OK-0.01)) as OKBezettingET_OK

((OKBezettingOKKamer<>previous(OKBezettingOKKamer) or OKBezettingOperatieDatum <> previous(OKBezettingOperatieDatum) or OKBezettingType <> previous(OKBezettingType

)), 'geen',

((OKBezettingOKKamer=previous(OKBezettingOKKamer) and OKBezettingOperatieDatum = previous(OKBezettingOperatieDatum) and OKBezettingType = previous(OKBezettingType)), 'geen',OKBezettingSpecialism)) as OKBezettingSpecialism

OKBezettingType

resident

OKMergetemp2;

OKMerge:

NOCONCATENATE

LOAD

RESIDENT

OKMergetemp2

ORDER

BY OKBezettingType ASC, OKBezettingOperatieDatum ASC, OKBezettingOKKamer ASC, OKBezettingBT_OK ASC

;

drop

TABLE

OKMergetemp2;

thanx all