topic Re: Static steps in Gantt chart in QlikView

Static steps in Gantt chart

ashis — Wed, 25 Nov 2020 16:16:04 GMT

I have a gantt chart , on the X axis I have time like

23:00:00 00:00:00 01:00:00 02:00:00 (hourly) , I want it to show every 15 minutes like

23:00:00 23:15:00 23:30:00

In my Axes I have static min =min(start_time) and in static step is mentioned as '00:15:00'

In number tab I have selected Time as hh:mm:ss

Please let me know how to get the x axis 15 minutes difference.

Re: Static steps in Gantt chart

jyothish8807 — Wed, 06 Jun 2018 06:15:01 GMT

Hi Ashis,

Can you please share a sample data and the chart sample you are trying to create ?

Br,

Re: Static steps in Gantt chart

jyothish8807 — Wed, 06 Jun 2018 07:28:31 GMT

Hi Ashis,

In static step 1 is eaqual to 24 hrs.

So you can set your steps accrodingly, ex 0.5 will give you 0:00, 12:00,24:00

Br,

Re: Static steps in Gantt chart

jyothish8807 — Wed, 06 Jun 2018 07:36:38 GMT

refer the attached.

Br,

Re: Static steps in Gantt chart

ashis — Wed, 06 Jun 2018 09:11:46 GMT

Hi Jyotish,

Thank you for your reply. If I put

'00:00:00' in static step I get around 30 minutes time difference.

The same expression that you used in your chart did not work in my chart.

Re: Static steps in Gantt chart

agomes1971 — Wed, 06 Jun 2018 10:54:49 GMT

Hi,

please read this:

creating Gantt Chart in Qlikview

HTH

André Gomes

Re: Static steps in Gantt chart

jyothish8807 — Fri, 08 Jun 2018 05:11:54 GMT

Can you share your sample chart ?

Br,

Re: Static steps in Gantt chart

ashis — Fri, 08 Jun 2018 05:20:56 GMT

HI Jyothiish,

Due to security reason I am unable to share the sample chart. Thank you for your reply though.

Re: Static steps in Gantt chart

jyothish8807 — Fri, 08 Jun 2018 06:02:31 GMT

Then i would recommend you to check the format of your output time you are creating from the expression.

It could be one reason. As far as i know i static step putting "00:00:00' will not work.

It has to be a numeric value.

Re: Static steps in Gantt chart

ashis — Tue, 12 Jun 2018 05:59:35 GMT

Hi Jyothish,

In my number tab I am using time hh:mm:ss format

In my Axes, static min =min(starttime)

in static step = 1/(60*24)*15

Then I get 3 hours interval such as 00:00:00 03:00:00 06:00:00

I am unable to make it 15 minutes interval.