March 07, 2016, 12:17 PM
Francis Mariani[SOLVED] JS Chart problem: negative value overlaps dimension name
I used the GUI many months ago to create a JS Chart type of bar chart (with subsequent manual edits, of course). I now have a problem when the chart renders - the negative value of one of the measures overlaps the dimension name. The fex below replicates my real-world problem. Any ideas? I don't see how I can reserve space for the dimension name so that the bar negative value does not overlap.
-SET &ECHO=ON;
SET MSG=ON
DEFINE FILE CAR
WEIGHT/D20.6 =
IF COUNTRY EQ 'ENGLAND' THEN 2.16
ELSE IF COUNTRY EQ 'JAPAN' THEN 27.885
ELSE IF COUNTRY EQ 'ITALY' AND CAR EQ 'ALFA ROMEO' THEN 5.81
ELSE IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'BMW' THEN 9.60
ELSE IF COUNTRY EQ 'FRANCE' THEN 9.55
ELSE IF COUNTRY EQ 'ITALY' AND CAR EQ 'MASERATI' THEN 20.00
ELSE IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'AUDI' THEN -7.22
ELSE 0;
SHORTNAME/A12 =
IF COUNTRY EQ 'ENGLAND' THEN 'NDG QE'
ELSE IF COUNTRY EQ 'JAPAN' THEN 'GHI EVD QE'
ELSE IF COUNTRY EQ 'ITALY' AND CAR EQ 'ALFA ROMEO' THEN 'FF QE'
ELSE IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'BMW' THEN 'QWF IF'
ELSE IF COUNTRY EQ 'FRANCE' THEN 'PPC Bands'
ELSE IF COUNTRY EQ 'ITALY' AND CAR EQ 'MASERATI' THEN 'DAF'
ELSE IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'AUDI' THEN 'Total Cash'
ELSE 'X';
SORT_SEQ/I2 =
IF COUNTRY EQ 'ENGLAND' THEN 1
ELSE IF COUNTRY EQ 'JAPAN' THEN 2
ELSE IF COUNTRY EQ 'ITALY' AND CAR EQ 'ALFA ROMEO' THEN 3
ELSE IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'BMW' THEN 4
ELSE IF COUNTRY EQ 'FRANCE' THEN 5
ELSE IF COUNTRY EQ 'ITALY' AND CAR EQ 'MASERATI' THEN 6
ELSE IF COUNTRY EQ 'W GERMANY' AND CAR EQ 'AUDI' THEN 7
ELSE 99;
END
-RUN
TABLE FILE CAR
SUM
MIN.WEIGHT
MIN.SHORTNAME
MIN.SORT_SEQ
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON TABLE HOLD AS HROLLUP1
END
-RUN
ENGINE INT CACHE SET ON
-SET &WF_STYLE_UNITS='PIXELS';
-SET &WF_STYLE_HEIGHT='220.0';
-SET &WF_STYLE_WIDTH='460.0';
GRAPH FILE HROLLUP1
-* Originally created by Info Assist for Graph
SUM
WEIGHT AS 'Weight'
BY SORT_SEQ NOPRINT
BY SHORTNAME AS 'Category'
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET LOOKGRAPH HBAR
-*ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT='Testing', $
*GRAPH_SCRIPT
setToolTipDisplay(false);
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getO1Title(),false);
setDisplay(getDataText(0), true);
setDisplay(getY1Title(),false);
setTextFormatPreset(getDataText(),30);
setDisplay(getDataText(),true);
setUseNegativeDataTextColor(true);
setColorMode(2);
setDisplay(getY1Label(),false);
setFontName(getO1Label(),"CALIBRI");
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 10);
setPlaceResize(getO1Label(), 0);
setFontSizeAbsolute(getDataText(),true);
setAutofit(getDataText(),false);
setFontSizeInPoints(getDataText(),10);
setPlaceResize(getDataText(),0);
setFontName(getDataText(),"CALIBRI");
setTransparentFillColor(getFrame(),true);
setFrameAutoShade(false);
setTransparentFillColor(getFrameSide(),true);
setTransparentBorderColor(getFrameSide(),true);
setTransparentFillColor(getFrameBottom(),true);
setTransparentBorderColor(getFrameBottom(),true);
setDisplay(getY1MajorGrid(),false);
setPieTilt(0);
setPieDepth(0);
setDepthRadius(0);
setDepthAngle(0);
setFillColor(getFrame(),new Color(225,225,231));
setDisplay(getO1MajorGrid(),false);
setDataTextPosition(1);
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(061,128,161)); // #3D80A1 - CDN EQ
setFillColor(getSeries(1),new Color(086,155,190)); // #569BBE - FGN DEV EQ
setFillColor(getSeries(2),new Color(140,186,212)); // #8CBAD4 - EM EQ
setFillColor(getSeries(3),new Color(182,102,022)); // #B66616 - NOM FI
setFillColor(getSeries(4),new Color(209,117,025)); // #D17519 - CPP Bonds
setFillColor(getSeries(5),new Color(233,150,067)); // #E99643 - FSB
setFillColor(getSeries(6),new Color(204,181,118)); // #CCB576 - Total Cash
*GRAPH_JS
"mouseOverIndicator": {
"enabled": true,
"color": "rgba(255,255,255,0.3)",
"marker": {"size": 0}
},
"riserBevel": "none"
,"yaxis": {
"baseLineStyle": {"width": 2, "color": "rgb(138, 138, 138)"},
"bodyLineStyle": {"width": 2, "color": "white"}
}
,"xaxisOrdinal": {
"bodyLineStyle": {"width": 2, "color": "white"}
}
*END
ENDSTYLE
END
-RUN
This message has been edited. Last edited by: Francis Mariani, 
