Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count distincvt if 3 conditions are met in set analysis

I would like to know how many unique "Service_Order_Number" exist if the "expense_type' = labor, the "...type_description" = "travel_time", and the the amount of travel time ("invoiced_qty...") is equal to zero. Basically, unique service calls that have no travel time invoiced against them.  I get no returns? =COUNT({$}DISTINCT Service_Order_Number)

10 Replies
Anonymous
Not applicable
Author

Actually it works - thanks again