Show data for a dimension associated with the selected dimension

[dukane24]

Hello,

I am simply trying to create an expression in a text object that will show a count of items for a Region if a State in that Region is selected.  For example, if someone selects Boston, I want to show the count of items for the Northeast Region.

This is the expression I'm using, but it is not working the way I want it to.  It is only showing the Count for the state I select, not the Region:

='Count: ' &
num(
     Count({<Region = $::Region>}Distinct ID)
,'##0.00')

I would appreciate any ideas you may have.  Thank you!

[Brett_Bleess]

Try the following Design Blog posts, should be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett