https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335055#M8576 <P>Is there a way to set the toggle as N if it is off?</P> Wed, 04 Oct 2023 17:40:32 GMT apgis16 2023-10-04T17:40:32Z https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1334993#M8570 <P>I am having difficulties figuring out how to filter. I have a Web Map with one layer on it with 4 fields with domains Y or N. I want to be able to toggle on the data based on FieldA = Y. If only one filter is on I want it to show data for FieldA=Y and the rest of the fields being N. Right now, the map is filtering only for Field A=Y but the other Fields are both Y or N.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AvaPatterson_0-1696435102471.png"><img src="https://community.esri.com/t5/image/serverpage/image-id/82289i0C26DAA96DC12B34/image-size/medium?v=v2&amp;px=400" alt="AvaPatterson_0-1696435102471.png" title="AvaPatterson_0-1696435102471.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Wed, 04 Oct 2023 16:01:04 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1334993#M8570 apgis16 2023-10-04T16:01:04Z https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335039#M8572 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JeffreyThompson2_0-1696439102928.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/82300iB61FDD20CC1B3BF8/image-size/medium?v=v2&amp;px=400" role="button" title="JeffreyThompson2_0-1696439102928.png" alt="JeffreyThompson2_0-1696439102928.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">JeffreyThompson2_0-1696439102928.png</span></span></P><P>You can go into the SQL Expression Builder and use the Add Clause Set option to create filters like: A is Y AND B is N AND C is N AND D is N.</P><P>The problem with this is that if a user selects A and B, they will get no results as it is impossible for B to be both Y and N.</P> Wed, 04 Oct 2023 17:11:41 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335039#M8572 JeffreyThompson2 2023-10-04T17:11:41Z https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335054#M8575 <P>I have a similar problem.</P><P>WAB does this fine if you turn the layer off in the base map, then your filters show only the points where Expression = TRUE.</P><P>To get this functionality in EB, you must create an additional toggle that is to be left turned on at all times...</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="abureaux_0-1696440866112.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/82302i5EF9BA3BFBA13056/image-size/medium?v=v2&amp;px=400" role="button" title="abureaux_0-1696440866112.png" alt="abureaux_0-1696440866112.png" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">abureaux_0-1696440866112.png</span></span></P><P>&nbsp;</P> Wed, 04 Oct 2023 17:36:00 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335054#M8575 abureaux 2023-10-04T17:36:00Z https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335055#M8576 <P>Is there a way to set the toggle as N if it is off?</P> Wed, 04 Oct 2023 17:40:32 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335055#M8576 apgis16 2023-10-04T17:40:32Z https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335071#M8578 <P>You could try something like this trick. I'm not sure it will work in your case.</P><P><A href="https://community.esri.com/t5/arcgis-experience-builder-questions/overwrite-default-map-filter/m-p/1269114" target="_blank">https://community.esri.com/t5/arcgis-experience-builder-questions/overwrite-default-map-filter/m-p/1269114</A></P> Wed, 04 Oct 2023 18:04:03 GMT https://community.esri.com/t5/arcgis-experience-builder-questions/filtering-toggling-on-data-on-fields-with-y-n-or-t/m-p/1335071#M8578 JeffreyThompson2 2023-10-04T18:04:03Z