Alexander Homer

Hi Erin and Robert, I believe I may have a solution, if I understand the use case correctly. Basically, the source that's providing the data values for each filter (such as an XML report if you're using dynamic values from a procedure in the Designer page) needs to also be filtered for the same amper variables so that the list of values will be filtered when passed to the control. Once put in place, this should provide the same kind of chaining behavior you get with the default filter configuration if you create a chaining hierarchy on the Filters tab. Check out the video below and let me know if that helps answer your question. Thanks! multilevel_chain_xml.mp4

Hi @Erin Trotter, Just to confirm, did you have each filter one within the other, like in the image? I wasn't able to replicate the behavior (see attached gif), so maybe there are some particular details that are different in how I set it up: I was using 9.1.2 since I don't have access to a 9.1.1 environment, but they should be pretty similar The fields I used are not in a hierarchy in the Master File business view, but they are part of the same segment You can see in the video below that there is a brief separate reloading of values on the Author Name drop-down after I set only the Author Language. If you are not seeing this, there may be some issue with chaining that we can look into multilevel_chain_vid.mp4

interactions_example.mp4

Hi Robert, As I understand it, youre trying to pass the same value to two different parameters in an HTML page, like this image.png740632 18.9 KB If so, you can just choose not to auto-generate the control for the second report, and then you should be able to bind the control to both parameters in the Parameters view tab and set the control to reload both reports, as shown here: Let me know if theres something Im missing. I havent had issues joining with DEFINE fields per se (as sometimes DEFINEs with character functions are needed to reformat data to match values to another field), but there may be certain cases that dont work

Hi Ben, If youre writing a FOCEXEC, you can use WITHIN in the filter statement to chain a filter to a parent filter field, e.g. -DEFAULT &MODEL = _FOC_NULL; -DEFAULT &COUNTRY = _FOC_NULL; GRAPH FILE ibisamp/car -* Created by Designer for Graph SUM CAR.BODY.SALES BY CAR.CARREC.MODEL WHERE CAR.ORIGIN.COUNTRY EQ &COUNTRY.(OR(FIND CAR.ORIGIN.COUNTRY IN IBISAMP/CAR |FORMAT=A10,SORT=ASCENDING,FIELDNAME=CAR.ORIGIN.COUNTRY)).COUNTRY.; WHERE CAR.CARREC.MODEL EQ &MODEL.(OR(FIND CAR.CARREC.MODEL IN IBISAMP/CAR |FORMAT=A24,SORT=ASCENDING,FIELDNAME=CAR.CARREC.MODEL, WITHIN=COUNTRY)).MODEL.; ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET VZERO OFF ON GRAPH SET HAXIS 770.0 ON GRAPH SET VAXIS 405.0 ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET EMBEDHEADING ON ON GRAPH SET AUTOFIT ON ON GRAPH SET STYLE * INCLUDE=IBFS:/WFC/Global/Themes/Standard/Default/theme.sty,$ TYPE=REPORT, TITLETEXT=Chart1, ARREPORTSIZE=DIMENSION, ARFILTER_TARGET=*, CHART-COLOR-MEASURES=ON, ARGRAPHENGINE=JSCHART, $ TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $ TYPE=DATA, COLUMN=N2, BUCKET=y-axis(1), $ TYPE=FOOTING, BACKCOLOR=RGB(255 255 255), $ TYPE=GRANDTOTAL, OBJECT=TAG, FONT=CAMBRIA, COLOR=RGB(237 28 36), $ *GRAPH_SCRIPT *GRAPH_JS_FINAL blaProperties: { seriesLayout: stacked } *END ENDSTYLE END When you run, the two fields should chain in autoprompt. This may not work with some fields from different segments or dont have a clear relationship. Does this work for your example As Andreas said, Designer can also force chaining within the design time UI.

Hi Emily, Data rows in an accordion EXPANDBYROWTREE report are actually subtotals, so you use the SUBTOTAL item in the StyleSheet instead of the DATA item. You can then use OBJECT=TAG to select only the subtotal title, which appears as the sort value. TABLE FILE ibisamp/car SUM CAR.BODY.DEALER_COST CAR.BODY.RETAIL_COST CAR.BODY.SALES BY CAR.ORIGIN.COUNTRY ON CAR.ORIGIN.COUNTRY SUBHEAD "Click to view details for <COUNTRY" BY CAR.COMP.CAR BY CAR.CARREC.MODEL ON TABLE PCHOLD FORMAT HTML ON TABLE NOTOTAL ON TABLE SET CACHELINES 100 ON TABLE SET GRWIDTH 1 ON TABLE SET EXPANDBYROWTREE 1 ON TABLE SET DROPBLNKLINE ON ON TABLE SET STYLE * INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$ TYPE=REPORT,ORIENTATION=LANDSCAPE, $ TYPE=SUBTOTAL, BY=1, OBJECT=TAG, ALT='Drill to country', TARGET='_blank', URL=https://en.wikipedia.org/w/index.php(title=CAR.ORIGIN.COUNTRY), $ ENDSTYLE END -RUN The result appears as follows: Thanks, Alex

Hi Aimar, Assuming youre just trying to provide a filter prompt sorted by month name, there are a couple of ways you could do this, depending on whether you prefer to edit the metadata or the report procedure. If you are able to edit the metadata, simply changing the USAGE for the month name field in the Master File syntax from (what may be right now) an alpha format (like A12V) to a date format, like Mtr (full month name in mixed case), should allow WebFOCUS to understand that the values are month names and order them correctly. The field definition in the Master File may end up looking something like this: FIELDNAME=MONTH_C, ALIAS=MONTH_C, USAGE=Mtr, ACTUAL=A12V, MISSING=ON, TITLE='Month Name', DESCRIPTION='Month Name', $ One not-so-elegant way you could change the sort order at the fex level is by manually ordering the month values using a static list, like this. This is assuming all month values in your data are one of the 12 English month names: &MONTH_C.(January,February,March,April,May,June,July,August,September,October,November,December).Month.QUOTEDSTRING; Multiselect would look something like this: &MONTH_C.(OR(January,February,March,April,May,June,July,August,September,October,November,December)).Month Name.; If you want to show month names but need to pass month numbers, you could specify different display and actual values, like this: &MONTH_NR.(<January,1>,<February,2>,<March,3>,<April,4>,<May,5>,<June,6>,<July,7>,<August,8>,<September,9>,<October,10>,<November,11>,<December,12>).Month.;

Hi Benjamin, Matthews suggestion is a good option: the Submit button makes it so that parameter values are not passed to filtered procedures in the page until it is clicked, so if your procedure has one or more required parameters, it wont run until then. If you dont have parameters in your procedure, another option is to use some custom JavaScript. You can add a button to the page that creates a new container with your procedure. For example, we have this sample JavaScript used in a demo page that creates 4 containers when a button is clicked. You could adapt it so that only one container is created instead of the 4 in the example, and point to your procedure via an IBFS path which you can get from the files properties on the Home Page. See this attachment for some sample code that you could modify for your example: Page_Designer_JS.txt (8.3 KB) Finally, if your procedure is in XLSX format and runs directly as spreadsheet, you could create a simple HTML page with a hyperlink that points to the procedure, which is defined here https://kb.informationbuilders.com/topic/passing-parameter-values-page-8207. You could then add that HTML page to your environment as a URL object, and add that URL to your page. Thanks, Alex

Hi John, Although there is no option specifically in the Designer interface to achieve this, if you are willing to use the text editor you can set start points for different colors in a color scale using the colorScale:colors:start property. If you set a static start value for each color in the color scale, these start points will not change with changes in your data. You can create the basic chart in WebFOCUS Designer, and then edit it in the text editor by right-clicking it and clicking Edit with text editor. You can also create a new procedure using only the text editor by clicking Other on the Action bar on the Workspaces view of the WebFOCUS Home Page and then clicking Text Editor to create a FOCEXEC procedure. For example, the color scale in the following procedure starts red at 0, turns yellow at 250K, and turns green at 500K (you can run this procedure from text editor if you have the wf_retail sample files): GRAPH FILE WF_RETAIL_LITE SUM REVENUE_US QUANTITY_SOLD BY PRODUCT_CATEGORY ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET STYLE * TYPE=DATA, COLUMN=N1, BUCKET=x-axis,$ TYPE=DATA, COLUMN=N2, BUCKET=y-axis,$ TYPE=DATA, COLUMN=N3, BUCKET=color,$ *GRAPH_JS_FINAL "yaxis": {"majorGrid": {"visible": false}}, "xaxis": {"majorGrid": {"visible": false}}, "colorScale": { "colors": [ {"start": 0, "color": "red"}, {"start": 250000, "color": "yellow"}, {"start": 500000, "color": "green"} ] } *END ENDSTYLE END In the following example, the chart is now filtered, but still changes to yellow at 250K and green at 500K: GRAPH FILE WF_RETAIL_LITE SUM REVENUE_US QUANTITY_SOLD BY PRODUCT_CATEGORY WHERE TOTAL QUANTITY_SOLD LE 500000; ON GRAPH PCHOLD FORMAT JSCHART ON GRAPH SET LOOKGRAPH BAR ON GRAPH SET STYLE * TYPE=DATA, COLUMN=N1, BUCKET=x-axis,$ TYPE=DATA, COLUMN=N2, BUCKET=y-axis,$ TYPE=DATA, COLUMN=N3, BUCKET=color,$ *GRAPH_JS_FINAL "yaxis": {"majorGrid": {"visible": false}}, "xaxis": {"majorGrid": {"visible": false}}, "colorScale": { "colors": [ {"pin": 0, "color": "red"}, {"start": 250000, "color": "yellow"}, {"start": 500000, "color": "green"} ] } *END ENDSTYLE END So for your example, if you want, for instance, 0-30 to be red, 30-60 to be yellow, and 60 and higher to be green, you could use the following properties in the *GRAPH_JS_FINAL block of the chart procedure: "colorScale": { "colors": [ {"start": 0, "color": "red"}, {"start": 30, "color": "yellow"}, {"start": 60, "color": "green"} ] } See pp. 813 and 816 in https://webfocusinfocenter.informationbuilders.com/wfdesigner/pdfs7/wfjschart8207.pdf for documentation, and let me know if you have any questions. Thanks, Alex