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

How to get the total of a measure and show it in all rows of a table

I have an easy measure that does the following 

 

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

)

 

I then add another measure, which is the same but with only TOTAL suffix added to the two SUM functions.

This results in a table with the following values

alespooletto_0-1718014639470.png

But as you can see, while the values on the left are correct, the results on the right are not what I was looking for. The right one should be all 75.4% for each single row, because it's the total value at the top of the first column to the left. 

Let's make an example: 

Measure 1 Total measure
average: 50 average: 50
25 50
75 50

 

So the final result should be 50, because the 2 rows gave me a total average of 50, and all rows in the second measure should thus have 50. 

Labels (1)
10 Replies
alespooletto
Creator
Creator
Author

Wow thank you so much @PrashantSangle , it's been a rough ride but your help has solved this. Thank you again, wish you a good continuation.