SET PAGE=NOLEAD,STYLE=ENDEFLT,BYDISPLAY=ON,ASNAMES=ON
TABLE FILE ibisamp/ggsales PRINT SEQ_NO BY REGION BY DOLLARS AS 'SALES' IN-GROUPS-OF 4 TILES ON TABLE HOLD AS quartiles END
TABLE FILE quartiles SUM MAX.SALES AS 'MAXSALES' MIN.SALES AS 'MINSALES' ACROSS HIGHEST TILE BY REGION ON TABLE HOLD AS maxmin END
GRAPH FILE maxmin SUM MAXSALES4 MAXSALES3 MAXSALES2 MAXSALES1 MINSALES1 BY REGION ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET LOOKGRAPH BOXPLOT ON GRAPH SET STYLE * INCLUDE=endeflt.sty,$ *GRAPH_SCRIPT setReportParsingErrors(false); setSelectionEnableMove(false); setTextRotation(getO1Label(),0); setDisplay(getO1MajorGrid(),false); setTransparentFillColor(getFrame(),true); setBorderColor(getY1MajorGrid(),new Color(220,220,220)); *END ENDSTYLE END
This code gives me error saying Fieldname MAXSALES4 is not recognised. Kindly help. Also he 5 columns names that is getting generated is of same name so how to differentiate it and use it in the Graph file.This message has been edited. Last edited by: FP Mod Chuck,
August 21, 2020, 12:05 PM
FP Mod Chuck
Kokila
This code runs without issue in my 8.2.06 environment. The IN-GROUPS-OF creates the 4 field names and appends a sequence number on them so it really isn't the same field. Which version are you using?
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats