 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| Across column in a graph | Login/Join |
| Silver Member |
Hi, my graph code is something like: GRAPH FILE GRAPH1 PRINT RETURN ACROSS MTHYEAR ... here i stored 'Jan 05', 'Feb 05', ... 'Dec 05' in the column MTHYEAR. but in graph since across is there, it is sorting the column MTHYEAR and displaying 'Apr 05', 'Aug 05', 'Dec 05', etc in x-axis. i want it to be displayed in the order which is present in the table (in the order of months from Jan to Dec). can someone help me in this regard. Thanks dharma ------------------ WF v 7.1.1 OS - Win XP Output: PDF, EXL2K | ||
|
| Expert |
Use the COLUMNS verb - search on COLUMNS in the find tool
| |||||||||
|
| Expert |
Dharma, your variables are being sorted in alphabetical order, since they are specified as alpha characters. Changing them to smart dates would sort them in the proper order, however the smart date for month and year has that embedded comma thing, which makes icky labels. so tony's suggestion lets you place any set of variables in any specified order, eg: COLUMNS Jan_05 AND Feb_O5 AND Mar_05 ...etc. You might have to change your values to single words, without the blank .This message has been edited. Last edited by: susannah,
| |||||
|
| Silver Member |
Susannah, will that embedded comma come before the year like Jan '05? actually i want in that format only (an inverted comma before the year like '05). if its so then could you please provide some sample code? Thanks Dharma | |||
|
| Expert |
no, Dharma. i'm thinking more Jan,2005 The apostrophe (or inverted comma as you say) would really get in the way of specifying a character string, so its best to avoid them.
| |||||
|
| Expert |
Dharma, Using a smart date format of TMY will give you values such as JAN, 05 etc. and will sort as you require (as per Susannah's comments) but if you really want that single inverted quote (and I agree with Susannah here, it can sometimes be more trouble than it's worth) then you will need to resort to using the COLUMNS syntax. However, depending upon the reporting year, you will have to come up with a dynamic way of declaring the column values to include. e.g. If your report allows your users to select a year then specifying COLUMNS 'Jan ''05' AND Feb ''05' etc. will be needed with the 05 section being a variable value. In fact something like this - -DEFAULT &Year = '97'
DEFINE FILE GGSALES
MNTH/A17 = CHGDAT('YYMD','TM',EDIT(DATE),'A17');
YEAR/A17 = CHGDAT('YYMD','Y',EDIT(DATE),'A17');
MNTHYEAR/A7 = EDIT(MNTH,'9999$')|''''||EDIT(YEAR,'99$');
END
TABLE FILE GGSALES
SUM DOLLARS
ACROSS MNTHYEAR COLUMNS 'JAN ''&Year.EVAL' AND 'FEB ''&Year.EVAL' AND 'MAR ''&Year.EVAL'
AND 'APR ''&Year.EVAL' AND 'MAY ''&Year.EVAL' AND 'JUN ''&Year.EVAL'
AND 'JUL ''&Year.EVAL' AND 'AUG ''&Year.EVAL' AND 'SEP ''&Year.EVAL'
AND 'OCT ''&Year.EVAL' AND 'NOV ''&Year.EVAL' AND 'DEC ''&Year.EVAL'
ENDFor my money though I would stick with smart dates and the sorting control that they will provide you. T
| |||||||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |