hi, I have a chart that shows Part numbers on the X-Axis and Values on Y. Problem is that some of Part number has "comma" and that's why the Partnumber is showing incorrectly on the chart. Is there a way to to show "comma"?
ThanksThis message has been edited. Last edited by: <Emily McAllister>,
WebFOCUS 8202M
May 27, 2016, 04:58 PM
BM
I was able to fix the issue by changing ON GRAPH SET GRMERGE ADVANCE to ON GRAPH SET GRMERGE ON
and instead of ACROSS Partnumber COLUMNS used BY PartnumberSort NOPRINT BY Partnumber
Still curious to know how to use ACROSS Partnumber &COL where &COL is dynamically created with Partnumbers containing "," and '&B'
Thanks
WebFOCUS 8202M
June 01, 2016, 02:23 PM
Tamra
BM,
Are your referring to something such as:
ACROSS CAR COLUMNS '&CAR1' AND '&CAR2' AND '&CAR3'
Using dialogue manager you can set the value of the &var
-SET &CAR1 = 'JAGUAR'; -SET &CAR2 = 'AUDI';
Within the quotes you can add the comma and if there is '&' required you can use the following:
-SET &CAR3 = '&'|'abc';
Thank you for participating in the Focal Point Forum.
Kindest regards, Tamra Colangelo Focal Point Moderator - Information Builders Inc. * Summit 2016 – June
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
June 01, 2016, 05:07 PM
Francis Mariani
The original post mentions the problem is that the dimension column values contain commas and I think the issue is how to create the &COL variable which includes these column values.
&COL1 is created with the actual values. &COL2 is created by concatenating pre-existing variables containing single values. Both methods work. Please let us know if this is not what you're trying to do. I suspect you're trying method 2 - you need a lot of single quotes when playing with single quotes...
-SET &ECHO=ALL;
-SET &COL1 = ' ''FRANCE, TEST'' AND ''JAPAN, TEST'' AND ''ENGLAND, TEST'' AND ''W GERMANY, TEST'' AND ''ITALY, TEST'' ';
-SET &CN1 = 'FRANCE, TEST';
-SET &CN2 = 'JAPAN, TEST';
-SET &CN3 = 'ENGLAND, TEST';
-SET &CN4 = 'W GERMANY, TEST';
-SET &CN5 = 'ITALY, TEST';
-SET &COL2 = '''' | &CN1 | '''' | ' AND ' | '''' | &CN2 | '''' | ' AND ' | '''' | &CN3 | '''' | ' AND ' | '''' | &CN4 | '''' | ' AND ' | '''' | &CN5 | '''';
DEFINE FILE CAR
COUNTRY_TEST/A40=COUNTRY || ', TEST';
END
-RUN
ENGINE INT CACHE SET ON
-RUN
GRAPH FILE CAR
SUM DEALER_COST
ACROSS COUNTRY_TEST COLUMNS &COL2
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS PIXELS
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
setUseSeriesShapes(true);
setMarkerSizeDefault(50);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END
-RUN
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