Focal Point
[CLOSED] How to pass more than one value for a variable in FOCEX for a drilldown

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9297068076

May 26, 2014, 08:30 AM
Dipti
[CLOSED] How to pass more than one value for a variable in FOCEX for a drilldown
Hi,
Could you anyone please help me fix the below issue?
I have a variable which is &LIST_DC = 551,553
I want to pass both these values in drilldown focex and as a filter to the next level.
How do i do it?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6
Excel, HTML, PDF, et.
May 26, 2014, 09:57 AM
Francis Mariani
-SET &LIST_DC = '551,553';

TABLE FILE CAR
SUM 
SALES
BY COUNTRY

ON TABLE SET STYLE *
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=DUMMY1 (COUNTRY=COUNTRY LIST_DC='&LIST_DC'), $
ENDSTYLE
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server