Qlikview Gantt chart look a like

[#1]

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

[#2]

this is what it looks like in qlikview now:

[johnw · Accepted solution]

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.

[#4]

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

[#5]

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

[#6]

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

[#7]

hi

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

[#8]

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

,

if

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

)), '0' ,

if

((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

,

if

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

-0.01 ,

if

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

,

if

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

)), 'geen',

if

((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