Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
boryspower
Creator
Creator

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
hic
Former Employee
Former Employee

But a graphical solution looks nicer...

View solution in original post

4 Replies
boryspower
Creator
Creator
Author

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

hic
Former Employee
Former Employee

But a graphical solution looks nicer...

boryspower
Creator
Creator
Author

GREAT! Thanks!

RedSky001
Partner - Creator III
Partner - Creator III

Just used this, thanks!