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.
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!
I am also new for QV, but i have small kind of idea about "Gantt Chart".
I have 3 dimensions
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.
Gantt chartQV.zip 129.9 K
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
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?!
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
You need to have an understanding of how Java Script works though.
I hope this helps.
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.
LOAD "Campaign Group",
DATE("Start Date",'MM/DD/YYYY') AS [Start Date],
DATE("End Date",'MM/DD/YYYY') AS [End Date];
SQL SELECT *
I hope this helps.
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?