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.

Hi Laure,

Did you try:

PRODGRP= PRODGROUP),

with the comma after the closing paren (I'm sure it's a typo)...

Tom,
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.

Hi 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, 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.

Hi 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 NOPRINT
ACROSS 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 \...