Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis

Hello,

I have the data like this. Here I'm calculating the %Over time. = OverTime_Hrs/PlannedHrs

Now I'm trying to calculate the Number of staff who worked  in between >= 10.1 to <=15% in a text box. Please advise.

stalwar1

 

EMPLOYEE_IDPLANNED_HOURSACTUAL_HOURS_DOCOverTime_HOURS
62143440595155
62238440588148
6262644046727
62735440547107
62793440600.2160.2
63465440499.559.5
63563440930
638984404477
4242440487.547.5
643664404422
64829440577137
65120440517.577.5
1 Solution

Accepted Solutions
sunny_talwar

May be like this:

Count({<EMPLOTEE_ID = {"=OverTime_HOURS/PLANNED_HOURS >= 0.101 and OverTime_HOURS/PLANNED_HOURS <= 0.15"}>} EMPLOTEE_ID)

View solution in original post

4 Replies
sunny_talwar

May be like this:

Count({<EMPLOTEE_ID = {"=OverTime_HOURS/PLANNED_HOURS >= 0.101 and OverTime_HOURS/PLANNED_HOURS <= 0.15"}>} EMPLOTEE_ID)

rupamjyotidas
Specialist
Specialist

Something like this

=Count({<%Overtime = {">=10.1 and <=15"}>} EMPLOYEE_ID)

Script:

Not applicable
Author

hi das

{">=10.1 and <=15"}>}


do you think the 'and' is mandatory

rupamjyotidas
Specialist
Specialist

{">=10.1<=15"}>}


Should do the trick