I tried to do it graphically and after tearing my hair out modified the code
8.0.1
October 24, 2016, 09:39 AM
Martin vK
Hi Brian,
There will be different ways to accomplish, but below code should work, or at least put you on track.
SET ASNAMES=ON
TABLE FILE ibisamp/car
SUM SALES
BY COUNTRY
BY CAR
ON TABLE HOLD AS HOLD1
END
-RUN
TABLE FILE HOLD1
SUM MAX.SALES AS HIGHESTVALUE
MIN.SALES AS LOWESTVALUE
BY COUNTRY
ON TABLE HOLD AS HOLD2
END
-RUN
JOIN COUNTRY IN HOLD1 TO COUNTRY IN HOLD2
TABLE FILE HOLD1
SUM FST.LOWESTVALUE NOPRINT
FST.HIGHESTVALUE NOPRINT
BY COUNTRY
SUM SALES
BY COUNTRY
ACROSS CAR
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=SALES, COLOR=RED, WHEN=SALES EQ C1, $
TYPE=DATA, ACROSSCOLUMN=SALES, COLOR=GREEN, WHEN=SALES EQ C2, $
ENDSTYLE
END
Martin
WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
October 26, 2016, 03:35 PM
Tamra
Brian,
The suggestion from our helpful members is using code. Once you edit the report and add code you will not be able to use the GUI Tool.
For the styling within InfoAssist GUI tool try to work with the following to set up the colors you are looking for.
Highlight "field" in the Query pane > Right mouse click > "More" > "Traffic Light Conditions. - there are options within here
Let us know which way works for you.
Kind Regards, Tamra Colangelo IBI Technical Support 1-800-736-6130
WebFOCUS 8x - BI Portal, Developer Studio, App Studio, Excel, PDF, Active Formats and HTML5
November 02, 2016, 10:29 AM
Brian Baird
quote:
y
Thank you very much for the responses and apologies for the delay in replying.
I've used InfoAssist completely with no coding following the ideas given by Martin vK.