Hiho,
im trying to generate a drill down from a graph.

Mygraph:
-SET &GRMERGE=IF &RELEASE_UI NE _FOC_NULL THEN 'ADVANCED' ELSE 'ON';
-SET &GRWIDTH=IF &RELEASE_UI NE _FOC_NULL THEN '3' ELSE '1';
-SET &GRMULTIGRAPH =IF &RELEASE_UI NE _FOC_NULL THEN '1' ELSE '0:';
-SET &BYCLAUSE= IF &RELEASE_UI NE _FOC_NULL THEN 'BY RELEASE_INFO_PERM_ALL_DEFECTS_FINAL.SEG01.RELEASE_UI' ELSE '';
-SET &HEAD = IF &RELEASE_UI NE _FOC_NULL THEN ' : ' ELSE ' : Summary';
-SET &PARAM = '_FOC_NULL';
-****************************************************************************


ENGINE INT CACHE SET ON
GRAPH FILE RELEASE_INFO_PERM_ALL_DEFECTS_FINAL
...
RELEASE_INFO_PERM_ALL_DEFECTS_FINAL.SEG01.SEVERITY NOPRINT
&BYCLAUSE
...
HEADING
"&HEAD"
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH &GRWIDTH
ON GRAPH SET EMBEDHEADING ON
ON GRAPH SET HAXIS 445.0
ON GRAPH SET VAXIS 400.0
ON GRAPH SET GRMERGE &GRMERGE
ON GRAPH SET GRMULTIGRAPH &GRMULTIGRAPH
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *

...

So if a user selects ALL in a Listbox, the graph will create a comulated single graph. if more entrys selected a multiple graph is drawn.

This works fine.

Now i want to generate a drill down for that:
...
TYPE=DATA, COLUMN=S1_INT, TARGET='_self', FOCEXEC=IBFS:....fex( RELEASE_UI=&RELEASE_UI.QUOTEDSTRING ), $
...

This will work for the single graph, because _FOC_NULL is given to the text. But this will not work in Multigraphs, because the value of the parameter will be 'x' OR 'y' OR.....

I have tried something like this:

-SET &newparam = IF &RELEASE_UI EQ _FOC_NULL THEN _FOC_NULL ELSE RELEASE_UI

and put &newparam in the fex.

This works for multiple graphs but not for the single one.

I need a way to assign a variable to have the value _FOC_NULL, like -SET &XY =_FOC_NULL

Or maybe a conditional drill down request like
if ¶m eq _FOC NULL then ... else .....


Any Suggestions?

Thnx

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

Hi,

I'm probably being a bit "dim" - so I may not have fully understood what the problem is - but it is Friday after all, so I think I can be forgiven ;-)

However, perhaps this would work:

-SET &newparam = IF &RELEASE_UI EQ '_FOC_NULL' THEN 'ALL_SELECTED' ELSE 'RELEASE_UI' ;

.... and then:

-IF &newparam EQ 'ALL_SELECTED' GOTO 'STEP_ALL';
TYPE=DATA, COLUMN=S1_INT, TARGET='_self', FOCEXEC=IBFS:....fex( RELEASE_UI=RELEASE_UI ), $
-GOTO CARRY_ON
-STEP_ALL
TYPE=DATA, COLUMN=S1_INT, TARGET='_self', FOCEXEC=IBFS:....fex( RELEASE_UI='_FOC_NULL' ), $
-CARRY_ON

Oh, and 'STEP_ALL' shouldn't be in single quotes in the GOTO i.e. should be:

-IF &newparam EQ 'ALL_SELECTED' GOTO STEP_ALL ;

Thnx, that works.