Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
felisberto_joao
Contributor III
Contributor III

problem with rangesum

Tela1.png

The column "Saldo Quant" sum all dimensions but I would like to sum only the data in dimension "Data Comercial", "Numord movimento", "Nota"

The expresion used is this one: RangeSum(Above(TOTAL [Quantidade Movimento], 0, NoOfRows(TOTAL)))

Best regards,

Felisberto

1 Reply
sunny_talwar

So the accumulation needs to restart when Filial Commercial changes? You will need to use Aggr() function to get this fixed. Exact expression would be rather difficult to provide because of the complexity, but if you can provide a sample, we might be able to help