The measures are defined as D16B but the hover text shows the - sign for negative numbers.

I don't display the text over the graph bars or lines, which is what I think setDataTextFormat is for. Is there a command to modify the format of the hover text?

Thanks,

This message has been edited. Last edited by: Kerry,

This sample graph shows the brackets for me in the hover (ToolTip) text.

DEFINE  FILE CAR
 PCTVAL/D6.2B = DECODE COUNTRY('ENGLAND' 5.5 'ITALY' -9.9 ELSE 0) ;
END
GRAPH   FILE CAR
 SUM 
        PCTVAL
 BY COUNTRY
 ON GRAPH SET LOOKGRAPH VBAR
 ON GRAPH SET GRAPHEDIT SERVER
 ON GRAPH SET GRAPHSTYLE *
 setDataTextDisplay (true);
 setTextFormatPreset(getSeries(0),-1);
 setTextFormatPattern(getSeries(0),"#0.00'%';(#0.00'%)'");
 setTextFormatPreset (getY1Label(), -1);
 setTextFormatPattern (getY1Label(),"#0.00'%';(#0.00'%)'");
 ENDSTYLE
END

Waz, thanks for the example. I managed to make it work for me. I find it annoying you have to specify a format for something as basic as this.

GRAPH FILE CAR
SUM 
COMPUTE SALESN/D10B = SALES * (-1); AS 'Sales'
BY COUNTRY AS ''

ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET GRAPHSTYLE *
-*setDataTextDisplay (true);
-*setTextFormatPreset(getSeries(0),-1);
setTextFormatPattern(getSeries(0),"#,###'%';(#,###'%)'");
-*setTextFormatPreset (getY1Label(), -1);
setTextFormatPattern (getY1Label(),"#,###'%';(#,###'%)'");
ENDSTYLE
END

Cheers,

Of course, this only works in this simple example - it doesn't work in a more complex graph:

GRAPH FILE HTREND1
-* Created by Advanced Graph Assistant
SUM
PURCHASES/D16B AS '&L_PUR'
REDEMPTIONS/D16B AS '&L_RED'
TRANSFERS/D16B AS '&L_TRA'
NETSALES/D16B AS '&L_SAL'

MIN.&DIMENSION2 NOPRINT

ACROSS &DIMENSION AS ''

ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS &LINE_HAXIS
ON GRAPH SET VAXIS &LINE_VAXIS
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIRIACharcoal.txt");
-*setFillColor(getChartBackground(),new Color(220,220,220));
setTextString(getTitle(),"&DB_TITLE_TREND");
setDisplay(getTitle(),&TITLE_DISP);
setFillColor(getTitle(),new Color(66,70,73));
setFontSizeAbsolute(getTitle(), true);
setFontSizeInPoints(getTitle(), 10);
setPlaceResize(getTitle(), 0);
setFontStyle(getTitle(),2);
setAutoSkip(getO1Label(),2);
setBorderColor(getO1AxisLine(),new Color(128,128,128));
setBorderColor(getO1MajorGrid(),new Color(128,128,128));
setBorderColor(getSeries(0),new Color(0,0,255));
setBorderColor(getStackConnectLine(),new Color(66,70,73));
setBorderColor(getY1MajorGrid(),new Color(128,128,128));
setDepthAngle(0);
setDepthRadius(0);
setDisplay(getDataText(),false);
setDisplay(getDataTextStackedTotalOnTop(),false);
setDisplay(getO1AltFmtFrame(),false);
setDisplay(getO1MajorGrid(),true);
setDisplay(getO1MajorGridColorBand1(),false);
setDisplay(getO1MinorGrid(),false);
setDisplay(getReferenceLineO1(0),false);
setDisplay(getStackConnectLine(),false);
setDisplay(getY1FrontZeroLine(),false);
setDisplay(getY1MajorGrid(),true);
setDisplay(getY1MajorGridColorBand1(),true);
setDisplay(getY1MajorGridColorBand2(),false);
setDisplay(getY1ZeroLine(),false);
setExcludeMaxLabel(getY1Label(),true);
setExcludeMinLabel(getO1Label(),false);
setExcludeMinLabel(getY1Label(),true);
setExtendToFrameEdge(true);
setFillColor(getLegendText(),new Color(66,70,73));
setFillColor(getO1AxisLine(),new Color(255,255,255));
setFillColor(getO1Label(),new Color(66,70,73));
setFillColor(getO1MajorGrid(),new Color(255,255,255));
setFillColor(getO1Title(),new Color(66,70,73));
setFillColor(getSeries(0),new Color(0,0,255));
setFillColor(getSeries(1),new Color(255,0,0));
setFillColor(getSeries(2),new Color(255,128,64));
setFillColor(getSeries(3),new Color(0,128,0));
setFillColor(getSeries(4),new Color(66,70,73));
setFillColor(getY1Label(),new Color(66,70,73));
setFillColor(getY1MajorGridColorBand1(),new Color(255,255,255));
setFillColor(getY1MajorGridColorBand2(),new Color(192,192,192));
setFontName(getAllText(),"Arial");
setFontSizeAbsolute(getLegendText(),true);
setFontSizeAbsolute(getO1Label(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeInPoints(getLegendText(),&FONT_SIZE);
setFontSizeInPoints(getO1Label(),&FONT_SIZE);
setFontSizeInPoints(getY1Label(),&FONT_SIZE);
setGradientAutoDirectionMode(false);
setGridStyle(getO1MajorGrid(),0);
setGridStyle(getY1MajorGrid(),0);
setLabelMargin(getO1Label(),0);
setLabelStagger(getO1Label(),false);
setLeftInset(getBeveledLegend(),0);
setLeftInset(getBeveledRiser(),0);
setLegendAutomatic(true);
setLegendMarkerPosition(2);
setLegendMarkersPerRow(4);
setLegendOrient(1);
setLegendPosition(1);
setLegendSeriesCount(0);
setLegendSeriesStart(0);
setLegendTextAutofit(true);
setLegendTextAutosize(false);
setLineBasicStrokeType(getStackConnectLine(),0);
setLineBasicStrokeType(getY1MajorGrid(),11);
setLineBasicStrokeType(getY1ZeroLine(),0);
setLineStyleLegendMarkers(0);
setLineWidth(getO1AxisLine(),0);
setLineWidth(getO1MajorGrid(),0);
setLineWidth(getReferenceLineO1(0),0);
setLineWidth(getSeries(3),4);
setLineWidth(getStackConnectLine(),0);
setLineWidth(getY1ZeroLine(),2);
setLineWidthAllSeries(3);
setMarkerDisplay(true);
setMarkerShape(getAllSeries(),1);
setMarkerSizeDefault(&MARKER_SIZE);
setO1MajorGridStyle(0);
setPlace(true);
setPlaceResize(getLegendText(),0);
setPlaceResize(getO1Label(),0);
setPlaceResize(getY1Label(),0);
setPrimitiveAntialiasing(true);
setReportParsingErrors(false);
setRightInset(getBeveledLegend(),0);
setRightInset(getBeveledRiser(),0);
setRiserBarGroupSpacing(0);
setSelectionEnableMove(false);
setSeriesLineWidthDefault(4);
setSeriesType(0,0);
setSeriesType(1,0);
setSeriesType(2,0);
setSeriesType(3,0);
setSeriesType(4,0);
setSkipBegin(getO1Label(),0);
setSkipCount(getO1Label(),6);
setSmoothLines(false);
setSquareMarkers(true);
setTextAntialiasing(true);
setTextJustHoriz(getLegendText(),1);
setTextRotation(getLegendText(),0);
setTextRotation(getO1Label(),0);
setTextUnderlineType(getO1Label(),1);
setTopInset(getBeveledRiser(),0);
setTransparentBorderColor(getAllSeries(),true);
setTransparentBorderColor(getChartBackground(),true);
setTransparentFillColor(getAllSeries(),false);
setTransparentFillColor(getFrame(),false);
setTransparentFillColor(getLegendArea(),true);
setUseDefaultBubbleMarker(false);
setUseNegativeDataTextColor(true);
setUseSeriesShapes(true);
setY1MajorGridStyle(0);
-*setDataTextFormat(26);

setTextFormatPreset(getSeries(0),-1);
setTextFormatPattern(getSeries(0),"#,###;(#,###)");
setTextFormatPreset (getY1Label(), -1);
setTextFormatPattern (getY1Label(),"#,###;(#,###)");

ENDSTYLE

ON GRAPH SET STYLE *
...

FYI, Francis has a case opened regarding this issue and is currently being actively worked on.

Francis, please keep us posted on your final solution, thanks in advance for sharing with all.

Cheers,

Kerry

It's been a while since I visited this issue, but I think I've figured out when this occurs - if one of the measures is over 2,000,000,000, the commas do not display.

The tooltip that displays the dimension and measure values does not display the commas when one of the values is 2,000,000,000 or greater.

Please see try this fex. The highest value is greater than 2,000,000,000 and the commas do not display. Change 22679 t0 22678 and the commas display because the highest value is less than 2,000,000,000.

GRAPH FILE CAR
SUM
COMPUTE SALESN/D20 = SALES * 22679;

ACROSS COUNTRY

ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 520
ON GRAPH SET VAXIS 250
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH PIE
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
END