If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
can someone assist me with the below please?
I have 3 fields in my app - One is called 'DepartureStatus' the other one is called 'Trip' and the last one is called 'Location'
DepartureStatus field contains - OnTime,Late and Early and the Trip field contains Trip numbers and location has site departments.
What i want is show how many trips where on Time, early or late by location in a bar chart.
I'm having problems writing this expression - When I use sum(DepartureStatus) and use Location as Dimension i don't get a result but i do when i use Count - but the figure is incorrect.
Can someone shed some light on this please?
Thanks for your reply,
Please see above example data - all i want is to show how many Trips where On Time, Late or Early by Location in a bar chart.
Thank you guys ! both worked apart from I am getting a different figure in my app!
I have a total of 41 Distinct trips
But my graph is showing 29 Lates, 28 On time and 1 Early??
I should have been more accurate with my data source - I will have duplicate lines of trip number hence me using Distinct Trip.
How can the trip number have duplicate lines?
Do you have more than one DepartureStatus per trip number? If so, you shouldn't use Count(Distinct Trip) but just Count(Trip).