Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
win_anthony
Partner - Contributor III
Partner - Contributor III

Average Shortest Length of Tenure for Employee

The goal is to create an expression that will calculate the average length of service per employee < 1yr of service. Below is a sample table and the syntax that I tried but is not working. 

Any thoughts? 

Syntax that is not working > =Sum({<[Length of Service]={'<=1'} >}[Length of Service])/Count(DISTINCT Emp_ID)

 

Emp_IDDeptLength of Tenure
1Shipping0.2
2Packing5
3Cashier0.7
4Management0.4
Labels (1)
1 Solution

Accepted Solutions
Saravanan_Desingh

Sum({<[Length of Service]={"<=1"} >}[Length of Service])/Count(DISTINCT Emp_ID)

 

Single quote represent a String. Can you try double quote?

View solution in original post

1 Reply
Saravanan_Desingh

Sum({<[Length of Service]={"<=1"} >}[Length of Service])/Count(DISTINCT Emp_ID)

 

Single quote represent a String. Can you try double quote?