Discussion board where members can get started with Qlik Sense.
I have a bar chart, with sum sales per year.
My problem is that i lose clients as the years increase. i want to make an acomulate sum with the clients.
i have 3 clients, and Sum(Sales) are 120 millons in 2015.
In 2016 i lose 1 client and the Sum(Sales) are 100millions.
The information in my table is:
Something like that
Thanks for all
Try this expression: sum(total Sales) - rangesum(above(sum(Sales),1,rowno()))
Sorry but It doesn´t work, y take negative values.
The year is the year y lose de client.
what is "total sales"?
Gysbert's expression seems to be working here: