Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
alespooletto
Creator
Creator

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