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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
alespooletto
Creator II
Creator II

Question about a measure that needs to be set for certain employees only

Hello, 

I have written a post about this question recently, but I am currently stuck once more. I can't understand how set analysis works in this case, because despite having inserted into the measure what I am looking for and having told the measure to use the set analysis over each function that needs it, the results do not match.

 

See screenshots below, when I don't select any employee, the measure 'Team Measure' works fine: 

alespooletto_0-1716359312836.png

 

However, when I select an employee, the measure suddenly turns to the same output as the employee selected: 

 

alespooletto_1-1716359353610.png

 

This is the measure I am currently using: 

 

// All Other Employees Measure
Sum(
    Aggr(
        {< Employee= >}  // Ignore selection of Employee
        Count({< ACTION_CODE = {'LABOR_OFF'} >} distinct MainSFC) * Time_Product,
        MainSFC, Employee
    )
)
/
(
Sum(
    Aggr(
        {< Employee= >}  // Ignore selection of Employee
        Count(distinct WorkingDay) * 7.5 * 60,
        Employee
    )
)
    -
	Sum(Absence) * 60

)

Can someone please help me figure out what I am doing wrong? 

 

Labels (1)
1 Reply
ali_hijazi
Partner - Master II
Partner - Master II

in the denominator you need to use the total
for example:
count(employee) / count(total {<employee=>}employee)

I can walk on water when it freezes