Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a production plan simmilar like on below picture:
[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):
... 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...
Go to Solution.
But a graphical solution looks nicer...
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
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:
Quite nice as for a short piece of code
Just used this, thanks!