Trying to have a Gantt Chart in Qlik Cloud

[GonçaloTomás]

Hi Everyone,

I'm working on a project using Qlik Cloud and I got a request from a user, in which it was requested to display the reload durations of some applications in a Gantt Chart for a date (that can be filtered), in order to know how long reloads take, and to check if reloads start at the same time as other reloads. These reloads are triggered via schedules. 

I've searched across the Qlik community and have seen some topics about this, but in the end I try to apply what I've seen in the following link, since it used native Qlik objects: 

• Creating a Gantt Chart in Qlik Sense - Qlik Community - 1606833 

The behavior is fine, when an application only reloads once per day, but when an application reloads more than one time per day, the last reload information is displayed in the chart as expected and according with what was defined in the set analysis expressions.

In the attached qvf, you can see the test data set. In that qvf, I have two sheets 'Gantt Chart - Version 1' and 'Gantt Chart - Version 2'.

In the first sheet, I have the following: one "bar" per App Name, but as you can see I have more than one reload for App Name C1.

In the second sheet, I have the following: have all bars for App Name C1, but they are separated (as exected, since the "field value" is different. I've created a field TableID via the function RecNo(), and then I've apply the Dual function (Dual([App Name],TableID) as [Gantt Chart App Name Unique])).

In my request, the desired output would be something like what can be seen in the image below, but I can't figure it out how to reach it, or if it's even possible. Does anyone have an idea on how to do this? Or does anyone have any alternatives to reach the desired output?

I've also tried to look for extensions, but in the end of the day the team would like to have this done with native objects, since we don't have control to add extensions into Qlik Cloud.

I can provide more information if needed.

Thank you in advance.

Best regards,

Gonçalo

[robert_mika]

Look here

Download the app

One tab will have an examples

https://community.qlik.com/t5/Official-Support-Articles/24-days-of-Visualization/ta-p/1875069

[GonçaloTomás]

Hi Robert,

Thank you for your response. I've seen the application and the examples, and my case and requirement is different, and doesn't fit in the example that was on the application.

Best regards,

Gonçalo