Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

boryspower
Contributor

Production plan on Gant chart

Hello,

I have a production plan simmilar like on below picture:

OrderStart dateStart timeFinish dateFinish time
MO_120120101600201201012400
MO_220120101120020120102335
MO_320120102400201201032351

[start time] is in format HHMM

I'd like to read this table to get a gant chart with production plan for days, like one below (black means production at this time of a day):

OrderDATE201201012012010220120103
MO_1
░░███████

MO_2
░░░░███████░░░░░░░
MO_3

░░████████████████




... or maybe You know other/better way to show production schedule and (the best would be) to be able to export it to excel for more detailed analysis...

1 Solution

Accepted Solutions
Employee
Employee

Re: Production plan on Gant chart

But a graphical solution looks nicer...

4 Replies
boryspower
Contributor

Production plan on Gant chart

Hi,

I will answer on my own problem Maybe someone will find it useful.

I did a part of script like this:

repeat('_',(STDT-20120101)*24+round(MSTI/100)-1) & Repeat('X',(FIDT-20120101)*24+round(MFTI/100)-(STDT-20120101)*24+round(MSTI/100)) as GANT_CHART

Explanation:

STDT = start date,

MSTI = start time,

FIDT = finish date,

MFTI = finish time,

I treated date 20120101 as a beginning of the period I'd like to see.

So as a result my table could look like this:

OrderGANT_CHART
MO_1_________XXXXXXX
MO_2_______________XXXXXXXXXXXXXXXXX
MO_3_____________________XXXXXXXX

Quite nice as for a short piece of code

Employee
Employee

Re: Production plan on Gant chart

But a graphical solution looks nicer...

boryspower
Contributor

Production plan on Gant chart

GREAT! Thanks!

msheraton
Contributor III

Production plan on Gant chart

Just used this, thanks!

Community Browser