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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make expression to only show overhead labor over 40 hrs/ week

Hi,

I want to make an expression that shows only Employee Overhead labor that is greater than 40 hrs a week. I am using an excel spreadsheet as the data source and have a Descrtion field that contains a list of all labor charge types. Presumably, I would add "ifs" to my expression to include those pertaining to voerhead hours, and once that is calculated, I would need the expression to then say, if overhead hours for a given week are greater than 40 hours, then display, if less than 40 hours or equal to 40 hours do not display.

Currently I have a chart that shows all employee overhead labor but team using ti would like to drill down further.

Here is the current Expression:

COUNT([Ovhd Hrs])



I am not sure how to aggregate this, any tips are aprpecaited.

Thanks.

1 Reply
Not applicable
Author

if(sum(T_Hours)>40,sum(T_Hours))