Solved: Count Greater than 1 - Qlik Community

danieldors · ‎2021-07-28

Hello,

I looking to only count the work type for those who completed more than 1 total driver. The expression below doesnt seem to be working. Any help is appreciated.

=((count({<[Total Driver]={">1"},[DD_Production.Date.autoCalendar.Date]={"$(=Max([DD_Production.Date.autoCalendar.Date])">}[Work Type]))))

Anil_Babu_Samineni · ‎2021-07-28

Perhaps this?

=((count({<[Total Driver]={"=Count([Total Driver])>1"},[DD_Production.Date.autoCalendar.Date]={"$(=Max([DD_Production.Date.autoCalendar.Date])">}[Work Type]))))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2021-07-28

Perhaps this?

=((count({<[Total Driver]={"=Count([Total Driver])>1"},[DD_Production.Date.autoCalendar.Date]={"$(=Max([DD_Production.Date.autoCalendar.Date])">}[Work Type]))))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful