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

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 II
Creator II
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.