[CASE-OPENED] Graph problem: Hover text displays negative numbers with - sign
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,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 22, 2012, 04:07 PM
Waz
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...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 23, 2012, 10:03 AM
Francis Mariani
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,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 23, 2012, 10:41 AM
Francis Mariani
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 *
...
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 26, 2012, 01:04 PM
Kerry
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
Kerry Zhan Focal Point Moderator Information Builders, Inc.
October 29, 2012, 10:40 PM
Francis Mariani
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
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server