The following gives me a graph with a lot of ticks but only a few labels. How do I remove ticks that do not belong to a label?

  
TABLE FILE EMPDATA
SUM
 SALARY
BY HIREDATE
ON TABLE HOLD AS H1
END
-RUN
-SET &I_NUM_RECS = &LINES;

DEFINE FILE H1
 GRP_DTE/YYMD=DATEMOV(HIREDATE, 'BOM');
 CTR/I4      =IF GRP_DTE NE LAST GRP_DTE THEN 1 ELSE CTR + 1;
 GRP_LBL/A21 =IF (HIREDATE EQ GRP_DTE) THEN DATETRAN(HIREDATE, '(MD)', '(Btr)', 'EN', 21, 'A21') ELSE ' ';
END
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4wPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5sYWJlbDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiIgPnRydWU8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiID4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF90YWJsZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY2hhcnRfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnNlcnRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+NTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkhGWVREMTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgIDwvT2JqZWN0Pgo8L1Jvb3Q+
-*Do not delete or modify the comments above
GRAPH FILE H1
-* Created by Advanced Graph Assistant
SUM 
H1.H1.SALARY AS 'Salary'
BY H1.H1.HIREDATE NOPRINT
BY H1.H1.GRP_LBL AS ' '
BY H1.H1.HIREDATE NOPRINT
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 752
ON GRAPH SET VAXIS 312
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 3
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIDefault.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(0);
setMarkerSizeDefault(50);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setTextString(getTitle(),"FYTD Asset Mix- Daily Market Value");
setPlaceAlign(getTitle(),0);
setTextJustHoriz(getTitle(),0);
setDisplay(getTitle(),true);
setUseTextBackgroundColor(getTitle(), true);
setTextBackgroundColor(getTitle(),new Color(255,197,18));
setLegendPosition(2);
setMarkerDisplay(false);
setSmoothLines(true);
setReverseGroups(false);
setLineWidthAllSeries(1);
setSeriesLineWidthDefault(1);
setFontName(getDataText(),"Calibri");
setFontStyle(getDataText(),2);
setFontSizeAbsolute(getDataText(),true);
setFontSizeInPoints(getDataText(),8);
setPlaceResize(getDataText(),0);
setFontName(getO1Label(),"Calibri");
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),8);
setPlaceResize(getO1Label(),0);
setTextRotation(getO1Label(),0);
setAutoSkip(getO1Label(),0);
setFillColor(getSeries(0),new Color(64,128,128));
setFillColor(getSeries(1),new Color(255,197,18));
setFillColor(getSeries(2),new Color(0,127,192));
setFillColor(getSeries(3),new Color(255,128,0));
setFillColor(getSeries(4),new Color(0,255,64));
setFillColor(getSeries(5),new Color(128,0,255));
setFillColor(getSeries(6),new Color(0,255,255));
setTransparentBorderColor(getFrame(),true);
setDisplay(getO1AxisLine(),false);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1MajorGridColorBand1(),true);
setFillColor(getY1MajorGridColorBand1(),new Color(168,188,193));
setDisplay(getY1MajorGridColorBand2(),true);
setFillColor(getY1MajorGridColorBand2(),new Color(229,237,255));
setBorderColor(getY1MajorGrid(),new Color(0,0,0));
setFillMissingData(2);
setUseSeriesShapes(false);
setSquareMarkers(false);
-*setO1MajorGridDisplay(false);
setIgnoreTickSkip(true);
ENDSTYLE
END
-RUN
-EXIT

-SET &ECHO=ALL;
-SET &GDATE='2012/10/02';

-*-SET &BDATE=AYMD('2012/10/02', -365);
-*WHERE BUS_DTE FROM '&I_BM_STR_DTE' TO '&P_BUS_DTE'

-* Conditions to display &P_BUS_DTE in the X-axis:
-* 1) The number of total days being plotted <= &I_BUS_DTE_MIN_DAYS
-SET &I_BUS_DTE_MIN_DAYS = 10;
-*    - or -
-* 2) Number of days from last ploted value >= &I_BUS_DTE_DAYS_FROM_LST_DAY
-SET &I_BUS_DTE_DAYS_FROM_LST_DAY = 3;
-*-GOTO TRY2;

TABLE FILE AM_ROLLUP
SUM
 AMVALUE
 COMPUTE TOT_CPP/D20.2=IF CATEGORYHIERARCHY EQ '10000000000' THEN AMVALUE / 1000000000 ELSE 0;
 COMPUTE CASH/D20.2   =IF CATEGORYHIERARCHY EQ '10100000000' THEN AMVALUE / 1000000000 ELSE 0;
 COMPUTE CDN_EQ/D20.2 =IF CATEGORYHIERARCHY EQ '10203010000' THEN AMVALUE / 1000000000 ELSE 0;
 COMPUTE GBL_EQ/D20.2 =IF CATEGORYHIERARCHY EQ '10203020000' THEN AMVALUE / 1000000000 ELSE 0;
 COMPUTE FI/D20.2     =IF CATEGORYHIERARCHY EQ '10205010000' THEN AMVALUE / 1000000000 ELSE 0;
 COMPUTE FSB/D20.2    =IF CATEGORYHIERARCHY EQ '10205020000' THEN AMVALUE / 1000000000 ELSE 0;
 COMPUTE PRE/D20.2    =IF CATEGORYHIERARCHY EQ '10207010000' THEN AMVALUE / 1000000000 ELSE 0;
 MAX.CATEGORYNAME
BY HIGHEST 365 VALUEDATE
BY CATEGORYHIERARCHY
IF REPORTID EQ 1
IF CATEGORYHIERARCHY EQ '10000000000' OR '10203030000' OR '10205010000' OR '10205020000' OR '10203020000' OR '10207010000' OR '10203010000'
IF VALUEDATE LE '&GDATE'
ON TABLE HOLD AS HFYTD1
END
-RUN
-SET &I_NUM_RECS = &LINES;

DEFINE FILE HFYTD1
 GRP_DTE/YYMD=DATEMOV(VALUEDATE, 'EOQ');
CTR/I4      =IF GRP_DTE NE LAST GRP_DTE THEN 1 ELSE CTR + 1;
 GRP_LBL/A12 =IF (VALUEDATE EQ GRP_DTE) OR (VALUEDATE EQ '&GDATE' AND ((CTR GE &I_BUS_DTE_DAYS_FROM_LST_DAY) OR (&I_NUM_RECS LE &I_BUS_DTE_MIN_DAYS))) THEN DATETRAN(VALUEDATE, '(MD)', '(Bt)', 'EN', 12, 'A12') ELSE ' ';
END
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4wPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5sYWJlbDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiIgPnRydWU8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiID4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF90YWJsZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY2hhcnRfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnNlcnRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+NTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkhGWVREMTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgIDwvT2JqZWN0Pgo8L1Jvb3Q+
-*Do not delete or modify the comments above
GRAPH FILE HFYTD1
-* Created by Advanced Graph Assistant
SUM HFYTD1.HFYTD1.TOT_CPP AS 'Total Consolidated CPP'
HFYTD1.HFYTD1.CASH AS 'Total Cash for Benefits Portfolio'
HFYTD1.HFYTD1.CDN_EQ AS 'Canadian Equities'
HFYTD1.HFYTD1.GBL_EQ AS 'Global Equities'
HFYTD1.HFYTD1.FI AS 'Fixed Income (ex FSB)'
HFYTD1.HFYTD1.FSB AS 'Foreign Sovereign Bonds'
HFYTD1.HFYTD1.PRE AS 'Public Real Estate'
BY HFYTD1.HFYTD1.VALUEDATE NOPRINT
BY HFYTD1.HFYTD1.GRP_LBL AS ' '
BY HFYTD1.HFYTD1.VALUEDATE NOPRINT
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 752
ON GRAPH SET VAXIS 312
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 3
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIDefault.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(0);
setMarkerSizeDefault(50);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setTextString(getTitle(),"FYTD Asset Mix- Daily Market Value");
setPlaceAlign(getTitle(),0);
setTextJustHoriz(getTitle(),0);
setDisplay(getTitle(),true);
setUseTextBackgroundColor(getTitle(), true);
setTextBackgroundColor(getTitle(),new Color(255,197,18));
setLegendPosition(2);
setMarkerDisplay(false);
setSmoothLines(true);
setReverseGroups(false);
setLineWidthAllSeries(1);
setSeriesLineWidthDefault(1);
setFontName(getDataText(),"Calibri");
setFontStyle(getDataText(),2);
setFontSizeAbsolute(getDataText(),true);
setFontSizeInPoints(getDataText(),8);
setPlaceResize(getDataText(),0);
setFontName(getO1Label(),"Calibri");
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),8);
setPlaceResize(getO1Label(),0);
setTextRotation(getO1Label(),0);
setAutoSkip(getO1Label(),0);
setFillColor(getSeries(0),new Color(64,128,128));
setFillColor(getSeries(1),new Color(255,197,18));
setFillColor(getSeries(2),new Color(0,127,192));
setFillColor(getSeries(3),new Color(255,128,0));
setFillColor(getSeries(4),new Color(0,255,64));
setFillColor(getSeries(5),new Color(128,0,255));
setFillColor(getSeries(6),new Color(0,255,255));
setTransparentBorderColor(getFrame(),true);
setDisplay(getO1AxisLine(),false);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1MajorGridColorBand1(),true);
setFillColor(getY1MajorGridColorBand1(),new Color(168,188,193));
setDisplay(getY1MajorGridColorBand2(),true);
setFillColor(getY1MajorGridColorBand2(),new Color(229,237,255));
setBorderColor(getY1MajorGrid(),new Color(0,0,0));
setFillMissingData(2);
setUseSeriesShapes(false);
setSquareMarkers(false);
-*setO1MajorGridDisplay(false);
setIgnoreTickSkip(true);
ENDSTYLE
END
-RUN

-TRY2
TABLE FILE HFYTD1
SUM HFYTD1.HFYTD1.TOT_CPP AS 'Total Consolidated CPP'
HFYTD1.HFYTD1.CASH AS 'Total Cash for Benefits Portfolio'
HFYTD1.HFYTD1.CDN_EQ AS 'Canadian Equities'
HFYTD1.HFYTD1.GBL_EQ AS 'Global Equities'
HFYTD1.HFYTD1.FI AS 'Fixed Income (ex FSB)'
HFYTD1.HFYTD1.FSB AS 'Foreign Sovereign Bonds'
HFYTD1.HFYTD1.PRE AS 'Public Real Estate'
BY HFYTD1.HFYTD1.VALUEDATE
WHERE VALUEDATE GE '2011/02/27'
WHERE VALUEDATE LE '2011/04/27'
END
-RUN
-EXIT
DEFINE FILE HFYTD1
 GRP_DTE/YYMD=DATEMOV(VALUEDATE, 'EOQ');
 CTR/I4      =IF GRP_DTE NE LAST GRP_DTE THEN 1 ELSE CTR + 1;
 GRP_LBL/A12 =IF (VALUEDATE EQ GRP_DTE) OR (VALUEDATE EQ '&GDATE' AND ((CTR GE &I_BUS_DTE_DAYS_FROM_LST_DAY) OR (&I_NUM_RECS LE &I_BUS_DTE_MIN_DAYS))) THEN DATETRAN(VALUEDATE, '(MD)', '(Bt)', 'EN', 12, 'A12') ELSE ' ';
END
TABLE FILE HFYTD2
SUM HFYTD2.HFYTD2.TOT_CPP AS 'Total Consolidated CPP'
HFYTD2.HFYTD2.CASH AS 'Total Cash for Benefits Portfolio'
HFYTD2.HFYTD2.CDN_EQ AS 'Canadian Equities'
HFYTD2.HFYTD2.GBL_EQ AS 'Global Equities'
HFYTD2.HFYTD2.FI AS 'Fixed Income (ex FSB)'
HFYTD2.HFYTD2.FSB AS 'Foreign Sovereign Bonds'
HFYTD2.HFYTD2.PRE AS 'Public Real Estate'
BY GRP_LBL
WHERE GRP_LBL NE ' ';
END
-RUN

-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4wPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5sYWJlbDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiIgPnRydWU8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiID4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF90YWJsZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY2hhcnRfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnNlcnRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+NTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkhGWVREMTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgIDwvT2JqZWN0Pgo8L1Jvb3Q+
-*Do not delete or modify the comments above
GRAPH FILE HFYTD2
-* Created by Advanced Graph Assistant
SUM HFYTD2.HFYTD2.TOT_CPP AS 'Total Consolidated CPP'
HFYTD2.HFYTD2.CASH AS 'Total Cash for Benefits Portfolio'
HFYTD2.HFYTD2.CDN_EQ AS 'Canadian Equities'
HFYTD2.HFYTD2.GBL_EQ AS 'Global Equities'
HFYTD2.HFYTD2.FI AS 'Fixed Income (ex FSB)'
HFYTD2.HFYTD2.FSB AS 'Foreign Sovereign Bonds'
HFYTD2.HFYTD2.PRE AS 'Public Real Estate'
BY HFYTD2.HFYTD2.GRP_LBL AS ' '
-*BY HFYTD2.HFYTD2.VALUEDATE NOPRINT
-*BY HFYTD2.HFYTD2.GRP_LBL AS ' '
-*BY HFYTD2.HFYTD2.VALUEDATE NOPRINT
WHERE GRP_LBL NE ' ';
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 752
ON GRAPH SET VAXIS 312
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIDefault.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(0);
setMarkerSizeDefault(50);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setTextString(getTitle(),"FYTD Asset Mix- Daily Market Value");
setPlaceAlign(getTitle(),0);
setTextJustHoriz(getTitle(),0);
setDisplay(getTitle(),true);
setUseTextBackgroundColor(getTitle(), true);
setTextBackgroundColor(getTitle(),new Color(255,197,18));
setLegendPosition(2);
setMarkerDisplay(false);
setSmoothLines(true);
setReverseGroups(false);
setLineWidthAllSeries(1);
setSeriesLineWidthDefault(1);
setFontName(getDataText(),"Calibri");
setFontStyle(getDataText(),2);
setFontSizeAbsolute(getDataText(),true);
setFontSizeInPoints(getDataText(),8);
setPlaceResize(getDataText(),0);
setFontName(getO1Label(),"Calibri");
setFontSizeAbsolute(getO1Label(),true);
setFontSizeInPoints(getO1Label(),8);
setPlaceResize(getO1Label(),0);
setTextRotation(getO1Label(),0);
setAutoSkip(getO1Label(),0);
setFillColor(getSeries(0),new Color(64,128,128));
setFillColor(getSeries(1),new Color(255,197,18));
setFillColor(getSeries(2),new Color(0,127,192));
setFillColor(getSeries(3),new Color(255,128,0));
setFillColor(getSeries(4),new Color(0,255,64));
setFillColor(getSeries(5),new Color(128,0,255));
setFillColor(getSeries(6),new Color(0,255,255));
setTransparentBorderColor(getFrame(),true);
setDisplay(getO1AxisLine(),false);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1MajorGridColorBand1(),true);
setFillColor(getY1MajorGridColorBand1(),new Color(168,188,193));
setDisplay(getY1MajorGridColorBand2(),true);
setFillColor(getY1MajorGridColorBand2(),new Color(229,237,255));
setBorderColor(getY1MajorGrid(),new Color(0,0,0));
setFillMissingData(2);
setUseSeriesShapes(false);
setSquareMarkers(false);
ENDSTYLE
END
-RUN

This message has been edited. Last edited by: Kerry,

quote:

GRP_LBL/A21 =IF (HIREDATE EQ GRP_DTE) THEN DATETRAN(HIREDATE, '(MD)', '(Btr)', 'EN', 21, 'A21') ELSE ' ';

If your hiredate isn't the first day of the month, you are setting the label to spaces. But you are summing the salary by HIREDATE

SUM 
H1.H1.SALARY AS 'Salary'
BY H1.H1.HIREDATE NOPRINT  <--  The label for this is blank if not the first of the month

BY H1.H1.GRP_LBL AS ' '  
BY H1.H1.HIREDATE NOPRINT <--  This is unneeded

To get rid of the unlabeled ticks, you need to sum your salary by year/month, but I don't know if that is really what you want.