How to have a chart always display a selection no batter what is really selected

[Anonymous]

I have an equation that gets me a safety exception and that works but my problem is I did this chart to show this information for Region when it is South no matter what is chosen by the user.

here is my current Safety equation.  How would I change this to show always for region south?

Avg([Total Distance Miles] / ([Speeding > 10 mph] + [Harsh Brake] + Seatbelt + [Hard Accel]))

[Anonymous]

Hey Sally, try using set analysis to solve this. The expression would be something like:

Avg({<Region="South">} [Total Distance Miles] / ([Speeding > 10 mph] + [Harsh Brake] + Seatbelt + [Hard Accel]))

Check out this resource from Qlik to learn more about set analysis. Good luck

[Anonymous · Accepted solution]

I figured it out.  For anyone wanting to know this is how you can set it.

Avg (  {<Region = {'South'} >}  ([Total Distance Miles] / ([Speeding > 10 mph] + [Harsh Brake] + Seatbelt + [Hard Accel])))