Search results for query: *

Mark, Not entirely sure what you question is. The way these IF statements work in WebFOCUS is simply to miss out sections of code if they are satisfied. There are no end statements when coding the -IF statements, webfocus simply reads the line, decides if the condition is met and then either...

hi, I'm not sure if I'm understanding your problem properly, if you want to display two graphs on one page, the easiest way to do it is like this: GRAPH FILE FILE1 SUM CNT.FIELD1 BY FIELD2 ON TABLE HOLD AS GRP1 FORMAT HTML END -RUN GRAPH FILE FILE2 SUM CNT.FIELD3 BY FIELD4 ON TABLE HOLD AS GRP2...

You can use Focus to check values in a file. You need to use ON TABLE HOLD AS filename FORMAT ALPHA, then filedef the file. You can then use IF fieldname IS (filename) or in a similar vein IF fieldname IS NOT (filename) in your code. You need to put this at the end of your WHERE statements or...

Hi Eva, Your code should look something like: DEFINE FILE XYZ LINE/I9=90; END GRAPH FILE XYZ SUM MON TUE WED THU MAX.LINE ACROSS PERCENTFIELD END then you can use the standard graph functions to set LINE to a line, (if the others are bars), remove the line markers, change the colour and...

Eva, One way that I use is to define a field in your graph that is equal to the value of the line. For example define a field called LINE which is equal to 90 and then sum the first value of this in your graph, you then get a straight line. You can colour the line easily then as its a data...

Go to the information builders website and download the Perspective for Java Programmers Manual (it's an acrobat file) it covers how to changes font sizes, colours, graph types etc. If you can't get at it there, post your e-mail address and I'll forward it to you. As to the angle of axis...

Are you computing the YEAR off the date rather than defining? When you use compute the report automatically includes the field used in the compute in the report. If this is what's causing the problem there are two options: 1. Move your compute into a define 2. Add the field yourself into the...

Hi Wayster, No doubt you have solved this by now, but just in case below is some text from a document I compiled for my own WebFOCUS users on Graphing. This gives the code required to enter into the edit text screen. To control the Y2 axis just change Y1 to Y2. As for controlling Axis titles, I...

You could define a field which concatenates your year field and department field into one field. i.e. if you department field is an A4 and year is an A4 then do DEFINE FILE filename DEPT_YR/A8=YEAR || DEPT; END GRAPH FILE filename SUM TOTAL_EMPLOYEE BY DEPT_YR etc Regards Tewy

Try this DATE1/I8=&YYMD; If you want the date in alpha format do DATE1/I8=&YYMD; DATE2/A8=EDIT(DATE1); Regards Tewy

Hi Oz, As your date field is stored in YYMD format, you can use the following in a define or compute: YEAR/YY=DATE; you can do the same for month or day by changing YY to M or D. Regards Tewy

Try this: TABLE FILE filename SUM UNIQUEID BY ORDER# BY HIGHEST 1 STATUS WHERE TOTAL STATUS NE 'Z'; END As 'Z' is higher than 'D' it should return one line per order number, with 'Z' for status if the order number is complete. The Where Total is evaluated after the data has been returned to...

Leo, The basic MATCH syntax is: MATCH FILE filename report request RUN FILE filename report request AFTER MATCH HOLD option END the match is performed on the BY fields used in the report request (which must have the same names). The are seven options to control what records are included in...

Hi Breyt, When I did my focus training (what seems like many years ago now), I was told the following: SET ALL=OFF is the same as MATCH .... OLD-AND-NEW SET ALL=ON is the same as MATCH .... OLD SET ALL=PASS is the same as MATCH .... OLD-NOT-NEW I have never tested the above so I suggest...

Hi Oz, There are many ways of doing this, I would use the &YYMD function to return the current date, a define for what you want would then look like this: DATE1/YYMD=&YYMD; DATE2/MDYY='11022002'; DIFF/I4=DATEDIF(DATE2, DATE1, 'M'); where DATE2 is the date returned from your HTML form. This...

Hi Eva, The following works for me setTextRotation(getO1Label(),0); it seems from your note that your referring to the X-axis as X (as would seem appropriate) but for most graph types in WebFOCUS (including bar charts) its referred to as the Ordinate axis hence the O above. Regards Tewy