Right click on the Set in your data window, choose "Create Calculated Field" and try to alias the In/Out values like:
IF [Diverstitures]=TRUE then "Include divestitures" else "Exclude divestitures" end
And use that as a quick filter instead of the set. Does that work for you? I just tested it and it worked well for me.
I knew it had to be easy!
Thanks a lot!
Matthew's suggestion is good. You might consider just using the code [Divestitures] and then aliasing the True/False values. With high volumes of data it is always good to avoid creating strings.
Another option is to simply edit the aliases of In and Out. An easy way to do this is to place the set on Rows and then right click the row header for In and Out and select "Edit Alias". Whatever value you enter there will show up in the quick filter option. I'd suggest this approach as it avoids an additional field.
You can customize the quick filter to be radio buttons by using the little drop down arrow in the upper right of the quick filter. You can also change the title, remove the "All" button, etc...
set_quick_filter.twbx 65.0 KB
Thanks Joshua--I thought there had to be a way to simply alias the True/False values.
You'll want to use Joshua's suggestion here, for sure. Glad he posted this.
thanks for this elegant solution! It even works if you have multiple sets. Apparently the aliases are set-specific.