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: 
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