topic Has anyone created Gantt Chart using QV10 Personal Edition? in QlikView

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 09:01:55 GMT

Hi All

Has any one created "Gantt Chart" using QV10 Personal Edition. If you have done it please let me know the steps to create the same please.

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 09:32:17 GMT

Hi Attitude,

Have you considered extension objects in v10 for a Gantt. If you have done a full install of QV10, then in folder C:\Program Files\QlikView_10IR\Examples\Extensions, double-click on the Gantt.qar file.

Then close/re-open v10 and in the start page you should see extension examples as a sample file, just under DataVisualizations. Might be helpful.

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 09:32:52 GMT

Btw, extension objects is only available in AJAX/Web mode, not for IE, etc.

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 11:24:03 GMT

Hi Cheenu

Thanks for your response!

I have already installed QV10 fully and double clicked on Gantt.qar. Also I am able to see the Gantt Chart once I have done this.

Problem is I want to know how to create the new Gantt Chart for my application. I don't have problem in viewing the Gantt Chart which is there in the "Getting Started" Tab.

Hope it is understandale now!

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 12:21:21 GMT

Hi Attitude,

I am also new for QV, but i have small kind of idea about "Gantt Chart".

I have 3 dimensions

1.Object

2.StartDate

3.EndDate

I want to show the only EndDate in Bar chart, it will looks like "Ganett Style" .

I was taken Object is a dimention,

In expression tab

1.StarDate as Start

2.EndDate as End

In expression tab select Start , Enable 'INVISIBLE" checkbox.

It willrepresents like this.

Regards,

Sampath Kumar.G

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 12:22:43 GMT

If it is not understandable. Shall I put this way!

Like the way we create the Bar Chart/Line Chart may I know how to create the Gantt Chart in QV10 Personal Edition. Could you please help me out on this?

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 12:35:52 GMT

Thanks Sampath for your effort

Yes it looks like Gantt Chart. But though it looks likes the Gantt chart may I know how to make you use of real Gantt chart using QV10 Personal Edition. How to create the real Gantt chart.

Has anyone created Gantt Chart using QV10 Personal Edition?

Qlik_Trigg — Thu, 17 Mar 2011 12:53:00 GMT

1. Start a new document

2. Load your data

3. Switch to WEBVIEW MODE (View ... Turn On/Off Webview)

4. In the sheet, RIGHT CLICK and select NEW SHEET OBJECT

5. Click on EXTENSION OBJECTS heading

6. If you have installed the Gantt Chart extension as stated, it should be listed

7. Drag the Gantt Chart onto your sheet.

8. Right click the chart to get to the properties

This should get you off and running. As shown in the Extensions Example, the Gantt Chart extension which is FLASH based will only work in the 32 bit version of QlikView Desktop/Personal Edition

Has anyone created Gantt Chart using QV10 Personal Edition?

Thu, 17 Mar 2011 13:23:56 GMT

Thank you so much John...

This is the one I was looking for. Now I will try to work on it and will try to create the chart using Gantt Chart.

Has anyone created Gantt Chart using QV10 Personal Edition?

Anonymous — Thu, 12 May 2011 11:53:18 GMT

Also followed John's example and got it working. Now I found that this Gantt Extension only works when I set the date format in the load script to 'MM/DD/YYYY' and not my default 'DD-MM-YYYY' as used in the Netherlands. And this causes me for any date-field displayed to use date formatting on field-level. Any ideas here?

Another question with this extension...

Is it possible to have influence on the scaling? For instance group by quarters instead of months?

Finally I found this extension to have quite a negative impact on the overall performance?!

Regards, Sander

Has anyone created Gantt Chart using QV10 Personal Edition?

siz_mahleka — Sat, 11 Jun 2011 12:57:08 GMT

Hi Sander,

Most of the manipulation for the Gantt Chart i.e. date format and date period grouping, can be found in the java script file for the extension. The location for the file is something like

C:\Users\{username}\AppData\Local\QlikTech\QlikView\Extensions\Objects\Gantt\Script.js

You need to have an understanding of how Java Script works though.

I hope this helps.

Regards,

Siz.

Has anyone created Gantt Chart using QV10 Personal Edition?

siz_mahleka — Sat, 11 Jun 2011 14:04:15 GMT

To change the date format, simply update the variable chartDateFormat in the Script.js file

var chartDateFormat = "dd/mm/yyyy";

// date format of the dates that are used in the chart. for example, European format would be dd/mm/yyyy

Please bear in mind that the input dates in the load script need to remain in the American format.

e.g.

LOAD "Campaign Group",

Campaign,

DATE("Start Date",'MM/DD/YYYY') AS [Start Date],

DATE("End Date",'MM/DD/YYYY') AS [End Date];

SQL SELECT *

FROM Demo.dbo.DimCampaign2;

I hope this helps.

Regards,

Siz.

Has anyone created Gantt Chart using QV10 Personal Edition?

Anonymous — Sat, 11 Jun 2011 14:42:59 GMT

Hi Siz,

Thanks for your explanation. I didn't know javascript was under the hood of these extensions. Works fine with the date format now. I'll have to take a deeper look into javascript coding for more changes in the extension script.

Regards, Sander

Has anyone created Gantt Chart using QV10 Personal Edition?

siz_mahleka — Sat, 11 Jun 2011 14:57:12 GMT

Great Sander,

If you do something interesting with the javascript please could you let us know what and how on this post as there is good potential with this extension.

Regards,

Siz.

Has anyone created Gantt Chart using QV10 Personal Edition?

Wed, 18 Jan 2012 10:56:42 GMT

Hi,

I'm having trouble changing the date format of the Gantt Extension. When using the default 'mm/dd/yyyy' format in the Script.js file the chart appears correctly. However when I change the chartDateFormat variable to 'dd/mm/yyyy' and reopen the qvw, the bars on the chart now display incorrectly and the dates still appear in the 'mm/dd/yyyy' format when I hover over them.

I'm leaving the input dates in the load script in the 'mm/dd/yyyy' format as you suggested. I've also tried changing this to the 'dd/mm/yyyy' but when I tried this the chart fails to load. The only change I made was to the chartDateFormat variable, am I doing something wrong?

Ideally I'd want to have the dates displayed in the following format: 'dd mmm yyyy' e.g. '18 Jan 2012'. Is this possible?

Thanks,

Tom