Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I want to display actualy Dates (in mm-dd-yy) format in the X-Axis. Presently it is showling numeric dates. I am attaching the data and Qlikview file with this post. Please help.
Hi
Assuming that the Gantt chart is a horizontal QV bar chart with offsets (and not an extension object), just go to Properties | Number and change the format there. If its not there, go to Document Properties | Numbernn and change the default format for the field to Date.
Regards
Jonathan
How about: Date(sum({$<Resource={'Ashish'}>}LENGTH), 'MM-DD-YY') ?
Regards,
Przemek
Hi
Assuming that the Gantt chart is a horizontal QV bar chart with offsets (and not an extension object), just go to Properties | Number and change the format there. If its not there, go to Document Properties | Numbernn and change the default format for the field to Date.
Regards
Jonathan
Thanks Jonathan, it worked !
Hi Rajeev
I have been working on a dedicated QlikView Gantt Chart extension object that also shows the task tree and lets the user expand & contract the tree. I have just posted a preliminary version of this here http://community.qlik.com/docs/DOC-3427
It is working well with the sample data I built. However I would be keen for others to try it and provide feedback through community (as comments attached through the link provided) so I can resolve any bugs and add functionality that people actually want.