Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Louveduval
Creator
Creator

Max in a table

Hello, 

I've this table with [nombre d'heure]=Sum([Temps Total]) and [lapin] =  RangeSum(Above(sum([Temps Total]),0,RowNo()))
Louveduval_0-1708694563680.png

But now, I would like to have the pourcentage of Nombre d'heure by the max(lapin) by activité 

Louveduval_1-1708695829633.png

can you help me ? 

 

Labels (3)
1 Solution

Accepted Solutions
marcus_sommer

You could get the needed partial total by applying a total-statement within the aggregation which may look like:

Sum([Temps Total])  / Sum(total < date, collabateur, activite> [Temps Total]) 

View solution in original post

2 Replies
marcus_sommer

You could get the needed partial total by applying a total-statement within the aggregation which may look like:

Sum([Temps Total])  / Sum(total < date, collabateur, activite> [Temps Total]) 

Louveduval
Creator
Creator
Author

it's perfect thank you