topic Re: Gantt Chart Axes in QlikView

Gantt Chart Axes

varunamin — Sat, 16 Nov 2024 18:48:42 GMT

Hi,

I am creating a gantt chart but the axes displays year 1900 instead of current year from data. Please let me now what needs to be changed. Thanks!

Re: Gantt Chart Axes

varunamin — Thu, 09 Apr 2020 21:29:12 GMT

Hi,

Any solution on this one. Please let me know. Thanks!

Re: Gantt Chart Axes

Frank_Hartmann — Fri, 10 Apr 2020 07:46:50 GMT

please share a sample qvw which demonstrates the issue

Re: Gantt Chart Axes

varunamin — Mon, 13 Apr 2020 21:00:10 GMT

Hi Frank,

Have attached a sample qvw. Need solution for below issues:

1) Date Range on X axis starts from 1900

2) Filter for Tested On should also display Month, Year format.

Please let me know what changes should be made. Thanks.

Re: Gantt Chart Axes

alex00321 — Tue, 14 Apr 2020 05:59:51 GMT

Hi you could check attached file to see if this works for you. thanks!

Re: Gantt Chart Axes

varunamin — Tue, 14 Apr 2020 20:21:04 GMT

Hi Alex,

Thanks! It worked but the Tested On filter shows blank when I replicate it on my dashboard.

Also is there a way to display the bars on a single row and the ones that overlap in the same time frame needs to be displayed on next row.

Re: Gantt Chart Axes

alex00321 — Wed, 15 Apr 2020 03:15:06 GMT

Hi for your first question, I'm using =DATE(date(SubField([Tested On],' ',1),'MM/DD/YYYY'),'MMM-YY') to group the Test on, so you could try to update based on your own needs. For the second one, seems not possible. Thanks!

Re: Gantt Chart Axes

varunamin — Wed, 15 Apr 2020 23:24:59 GMT

Hi Alex,

I am also having the same field (Tested On) and using the same expression. But it still shows empty list box.

Re: Gantt Chart Axes

alex00321 — Thu, 16 Apr 2020 01:36:57 GMT

Can you attach your application? Thanks!

Re: Gantt Chart Axes

varunamin — Thu, 16 Apr 2020 02:23:14 GMT

Hi Alex,

Have just added the filter on the dashboard that I am working on. Also need unique MM-YYYY values in Filter.

Thanks!

Re: Gantt Chart Axes

Brett_Bleess — Wed, 29 Apr 2020 17:42:14 GMT

Might want to check the following Design Blog post to see if it has what you need too:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Gantt-chart/ba-p/1469842

Regards,
Brett