Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
vish123
Creator III
Creator III

How to create Gantt Chart with multiple timelines using Anychart Resource or Project chart with below Data

Hi Team,

I have below sample data using which i have to create Gantt chart with multiple timelines. Can someone please suggest what is the data structure to be in which format in order to get below output. 

Index Brand Sub-Brand Phase1 Phase2 Phase3
  Start End Start End Start End
1 Brand1 Sub-Brand1 1-Feb-2022 7-Feb-2022 10-Mar-2022 15-Mar-2022 1-Apr-2022 7-Apr-2022
2 Brand2 Sub-Brand2 5-Feb-2022 9-Feb-2022 16-Mar-2022 20-Mar-2022 5-Apr-2022 9-Apr-2022

 

Output should be like below:

vish123_5-1653026541428.png

 

Please suggest or guide me ..Thanks in advance.

Labels (1)
1 Reply
TimLo
Contributor
Contributor

If your data looks like this:

Screen Shot 2022-09-20 at 13.23.00.png

Sample data set as google spreadsheet:

https://docs.google.com/spreadsheets/d/1IoJdU0YPu3dBUmgY-Z9aAj88aUsZH1VBQ_C9rZbpmmo/edit?usp=sharing

Then you need to create AnyGantt 4 Resource with the following dimensions: Brand, Sub-Brand, Phase and measures Min(Start) and Max(End):

Screen Shot 2022-09-20 at 13.26.25.png

And get the following result:

Screen Shot 2022-09-20 at 13.27.42.png

QVF App with the data attached.

Does this help?