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