Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative sum order by sales

Hi,

I have to create a table with 3 column: Customer, Sales, and a column with comulative sum. I done it with

rangesum(above(total sum(Sales), 0, rowno()))

But i have to order descending by Sales, and it don't works when I insert the cumulative sum, can anyone help me?

Regards

Daniele

1 Solution

Accepted Solutions
fred_s
Partner - Specialist
Partner - Specialist

- Create a Pivot table

- Dimension is Customer

- Sum(Sales) and running total are the expressions (see attachment previous post)

- Sort:

Running-total.JPG

Grtz Fred

View solution in original post

3 Replies
fred_s
Partner - Specialist
Partner - Specialist

Hi Daniele,

See attchm.

Grtz Fred

fred_s
Partner - Specialist
Partner - Specialist

- Create a Pivot table

- Dimension is Customer

- Sum(Sales) and running total are the expressions (see attachment previous post)

- Sort:

Running-total.JPG

Grtz Fred

Not applicable
Author

Hi Fred,

thanks for your help

Daniele