Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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