Focal Point
Passing specific stacked bar graph value to drilldown code
November 29, 2007, 08:28 AM
LaurePassing specific stacked bar graph value to drilldown code
I have a stacked bar graph whic counts the number of products within each product group across quarter.
GRAPH FILE PRDRLSE
SUM CNT.PRODFAM
ACROSS YEARQTR
BY PRODGROUP
...
ON GRAPH SET STYLE *
TYPE=DATA, FOCEXEC=TEST.FEX(YEARQTR=A1\
PRODGRP=
????)
TARGET='iframe2',$
I want to drill into the graph and pass the value of PRODGROUP to the called FEX. How do I reference the specific PRODGROUP column?
I've tried N1 and N2... N2 gives me the CNT.PRODFAM value, and N1 returns nothing.
Laure
Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF
November 29, 2007, 08:32 AM
Tom FlynnHi Laure,
Did you try:
PRODGRP= PRODGROUP),
with the comma after the closing paren (I'm sure it's a typo)...
Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 29, 2007, 02:57 PM
LaureTom,
That's the first thing I had tried. Nothing gets pass to the called fex.
My called fex, right now simply just types out the parameters that are passed.
-TYPE PRODGRP==&PRODGRP
-TYPE YEARQTR==&YEARQTR
-EXIT
&PRODGRP IS EMPTY. YET THE YEARQTR PASSES THE PROPER VALUE.
Laure
Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF
November 29, 2007, 04:29 PM
Tom FlynnHi Laure,
I thought you may have tried that; should have known better.
Here is an example for what you are trying to do:
-DEFAULT &CAR_SEL = ' ', &CNTRY_SEL = ' '
GRAPH FILE CAR
SUM
DEALER_COST
SALES
RETAIL_COST
COUNTRY NOPRINT <-------------------
ACROSS CAR
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET STYLE *
TYPE=DATA, FOCEXEC=TEST(CAR_SEL=A1 CNTRY_SEL = COUNTRY), $
ENDSTYLE
ON GRAPH SET GRAPHSTYLE *
setDisplay(getDataTextStackedTotalOnTop(), true);
setFillColor(getDataTextStackedTotalOnTop(),new Color(0,0,255));
setDataTextPosition(0);
setTextRotation(getDataTextStackedTotalOnTop(), 0);
setPlace(true);
END
-EXIT
Test.fex
-SET &ECHO=ALL;
-DEFAULT &CAR_SEL = ' '
-DEFAULT &CNTRY_SEL = ' '
TABLE FILE CAR
HEADING
"CAR"
"COUNTRY <+0> NAME <+0> SEAT"
" "
PRINT
CAR AS ''
SEAT AS ''
BY COUNTRY AS ''
WHERE COUNTRY EQ '&CNTRY_SEL.EVAL'; <----------
WHERE CAR EQ '&CAR_SEL.EVAL'; <----------
ON TABLE SET STYLE *
UNITS=IN, SQUEEZE=ON, ORIENTATION=PORTRAIT, $
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, $
TYPE=HEADING, HEADALIGN=BODY, SIZE=10, $
TYPE=HEADING, LINE=1, ITEM=1, POSITION=CAR, STYLE=NORMAL,$
TYPE=HEADING, LINE=2, ITEM=2, POSITION=CAR, STYLE=ITALIC,$
ENDSTYLE
END
-EXIT
I hope this helps...
Say Hi to all, if you dare! (lol)
Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
December 05, 2007, 08:00 AM
LaureTom, This won't work for me. The PRODGRP is BY, and the QTR is an ACROSS. So the PRODGRP value should already be available, but doesn't seem to be.
If I only have the BY it works fine.
Laure
Prod: WebFOCUS 7.7.03 - MRE, BID, - WindowsXP - Oracle 9i, SQLServer, DevStudio 7.7.3 - Apache Tomcat , Output: HTML, Excel 2013 and PDF
December 05, 2007, 12:27 PM
Tom FlynnHi Laure,
quote:
GRAPH FILE PRDRLSE
SUM CNT.PRODFAM
ACROSS YEARQTR
BY PRODGROUP
...
ON GRAPH SET STYLE *
TYPE=DATA, FOCEXEC=TEST.FEX(YEARQTR=A1 \
PRODGRP= PRODGROUP)
TARGET='iframe2',$
Adding
GRAPH FILE PRDRLSE
SUM CNT.PRODFAM
PRODGROUP NOPRINTACROSS YEARQTR
BY PRODGROUP
within the verb won't work??? I am surprised, should work..
I will assume there is a space between YEARQTR=A1 and your continuation slash \...
Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe