I'm new to Qlik Sense and I really like this product! I have done many things alone until today but I have a little issue that I can't find the reason...
What I want to do is to compute a sub-total value on all rows, which you may find in the attached screenshot. As you might see, there is one row where is written 161,43 and the others are blank.
How can I repeat 161,43 on all the rows? I used the aggr() formula as below:
Aggr( Sum ( WeightFull ), WaveFullName)
WaveFullName is the first column of my dataset. So the only issue is to repeat that 161,43 on all rows but I can't do that. I tried to use the Max() function with Aggr() or FirstSortedValue() but it doesn't work.