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