# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:
Creator II

## Count of users according to Time

Hello,

I have one requirement where i need to show Count of users with 80-100 hours of Time Duration in a month. The filed is calculated on a day to day basis. and Come as TimeDuration.

When one whole month is selected. Then in expression the below expression doesn't work:

=If(sum(TimeDuration)>288000 AND sum(TimeDuration)<=360000,
num(count({<TimeDuration={">288000<=360000"}>}distinct UserId),'#,##0'),'-')

Because in the set modifier the sum(TimeDuration) doesn't work. Can you please suggest an approach

1 Solution

Accepted Solutions
MVP

@shanky1907 try this

``Num(Count({<UserId = {"=Sum(TimeDuration) > 288000 and Sum(TimeDuration)<= 360000"}>}DISTINCT UserId), '#,##0')``
3 Replies
MVP

@shanky1907 try this

``Num(Count({<UserId = {"=Sum(TimeDuration) > 288000 and Sum(TimeDuration)<= 360000"}>}DISTINCT UserId), '#,##0')``
Creator II
Author

Fantastic as always.

MVP

Hahaha thanks, glad I was able to help @shanky1907

Community Browser