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"?

Thanks

This message has been edited. Last edited by: <Emily McAllister>,

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

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

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