Static steps in Gantt chart

[ashis]

Hi

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.

[jyothish8807]

Hi Ashis,

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

Br,

KC

[jyothish8807]

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,

KC

[jyothish8807]

refer the attached.

Br,

KC

[ashis]

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.

[agomes1971]

Hi,

please read this:

creating Gantt Chart in Qlikview

HTH

André Gomes

[jyothish8807]

Can you share your sample chart ?

Br,

KC

[ashis]

HI Jyothiish,

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

[jyothish8807]

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.

[ashis]

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.