I have two workbooks that I am loading into a single Qlik Sense application.
1. Toll Route Billing Information-
Approved for Toll Usage
Exit 1 to Exit 3
Exit 2 to Exit 1
Exit 3 to Exit 5
Exit 4 to Exit 5
2. Approved Vehicles- Composed of a list of vehicles broken down into several business groups
Vehicle Plate Number
Business Systems Group
In the Billing Information file, I have created a helper column to identify whether a vehicle is approved for toll usage, and I have used the helper column as a part of my Qlik Sense Application to calculate the number of approved vehicles in use (per filtered time frame- as defined by user in the application)
What I want to do is to use that count and calculate a percentage against the total number of approved vehicles in that group from the Approved Vehicles List. In this case it would be
Vehicles from the Toll Route Billing Information File (2) divided by the total number of vehicles in the Approved Vehicles File (3)
Result should be: 66%
I have been able to write the first part of the but I am experiencing difficulty adapting my expression.
What would be the best option for me to get this to work? If this has been resolved before please redirect me.
Is there a reason for this repeat of the business group in both tables? This doesn't make sense to me data model wise. I feel like this would make more sense if you had a vehicle dimension and maybe an attribute that said approved?