Dear All,
iam facing some Problem with Gauge Chart.iam setting the Minimum and Maximum Values for Gauge Chart.that is Q0 min and Q5 is the Max Values,and iam also setting the Dynamic Gauge Band Colors Depands up on these Q0 to Q5.here my probelm is i want to put the 5 GaugeMajor Ticks including Max and Min Values,that is
the first Value is :Q0
first Value is
Q5-Q0/4)+Q0
SECOND Value is
Q5-Q0/4)+FIRST VALUE
THIRD Value is
Q5-Q0/4)+SECOND Value
FOURTH Value is
Q5-Q0/4)+THIRD Value
FIFTH Value is
Q5-Q0/4)+FOUTH VALUE=Q5
I WANT TO PASS THESE VALUES DYNAMICALLY TO THE GAUGE MAJOR TICKS AND GAUGE BANDS ARE DEPANDS UP ON THESE Q0toQ5.
IAM PASTING MY CODE HERE.
****************************************
GRAPH FILE FT_BANKRUPTCY_CHAPTER
SUM ANNUALIZED_BANKRUPTCY_LOSS_RATE
ACROSS SUBSCRIBER_SITE
WHERE Loan_Origination_Type_Key EQ &LoanOrgKey;
WHERE Collateral_Type_Key EQ &CollateralKey;
WHERE SUBSCRIBER_KEY EQ &SubscriberKey;
WHERE Chapter_Key EQ &ChapterKey;
WHERE Time_Key EQ &TimeKey;
WHERE ( ANNUALIZED_BANKRUPTCY_LOSS_RATE IS-NOT MISSING );
ON GRAPH SET LOOKGRAPH GAUGE1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID OFF
ON GRAPH SET VAXIS &Height
ON GRAPH SET HAXIS &Width
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setFillColor(getGaugeValue(), new Color(0,0,0));
setFontStyle(getGaugeValue(), 2);
setFontName(getGaugeValue(), "Courier");
setFontSizeAbsolute(getGaugeValue(), true);
setFontSizeInPoints(getGaugeValue(),&gaugevalue);
setDisplay(getFrame(),false);
setFillColor(getGaugeNeedle(), new Color(0,128,255));
setDisplay(getGaugeTitle(), false);
setGaugeRelativeThickness(0.35);
setGaugeBackgroundStyle(8);
setGaugeIgnoreBackgroundStyle(true);
setGaugeRelativeInnerRadius(0.65);
setBorderColor(getGaugeMinorTick(), new Color(0,0,255));
setBorderColor(getGaugeMajorTick(), new Color(0,0,0));
setFillColor(getGaugeLabel(), new Color(0,0,35));
setFillColor(getGaugeBackground(), new Color(255,255,0));
setFontStyle(getGaugeLabel(), 0);
setFontSizeVC(getGaugeLabel(),1300);
setPlaceSkip(getO1Label(), 0);
setGaugeMajorAutoStep(false);
setY1MajorGridStep(&QGS);
setScaleFromZero(false);
setDisplay(getGaugeLabel(),true);
setDisplay(getGaugeMajorTick(),true);
setDisplay(getGaugeMinorTick(),false);
setY1ScaleMin(&Q0);
setY1ScaleMax(&Q5);
setTextFormatPreset(getY1Label(),4);
setGaugeBandMin(getGaugeBand1(), &Q0);
setGaugeBandMax(getGaugeBand1(), &Q1);
setGaugeBandMin(getGaugeBand2(), &Q1);
setGaugeBandMax(getGaugeBand2(), &Q2);
setGaugeBandMin(getGaugeBand3(), &Q2);
setGaugeBandMax(getGaugeBand3(), &Q3);
setGaugeBandMin(getGaugeBand4(), &Q3);
setGaugeBandMax(getGaugeBand4(), &Q4);
setGaugeBandMin(getGaugeBand5(), &Q4);
setGaugeBandMax(getGaugeBand5(), &Q5);
setBorderColor(getGaugeBand1(),new Color(0,0,0));
setBorderColor(getGaugeBand2(),new Color(0,0,0));
setBorderColor(getGaugeBand3(),new Color(0,0,0));
setBorderColor(getGaugeBand4(),new Color(0,0,0));
setBorderColor(getGaugeBand5(),new Color(0,0,0));
setFillColor(getGaugeBand1(),new Color(0,128,0));
setFillColor(getGaugeBand2(),new Color(153,204,0));
setFillColor(getGaugeBand3(),new Color(255,255,26));
setFillColor(getGaugeBand4(),new Color(255,153,0));
setFillColor(getGaugeBand5(),new Color(255,0,0));
ENDSTYLE
END
PLEASE GIVE ME A SOLUTION FOR THIS PROBLEM.
Thanks,
Kalyan.S
------------------------------------
WebFOCUS 7.1.4, Win XP SP2,
Oracle8i.
------------------------------------