Discussion board where members can get started with Qlik Sense.
Please help find optimal solution.
I have data - drivers delivers documents to different locations. To some locations may be delivered several document.
I need to count, how many locations were visited by driver each month.
I use construction:
COUNT (Location_Code) AS Count_Delivery_Points
But I guess, this construction counts repeated locations, when several documents were delivered to same location.
Can you please tell me, how to cunt only unique values?
Thank you in advance!
Go to Solution.
you could use the below expressions in a chart object:
measure : count( distinct Location_Code )
using a simple script like this:
COUNT (distinct Location_Code) AS Count_Delivery_Points