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

Rangesum on mutiple dimesion

Rangesum on mutiple dimesion

input table:

Load * Inline [
Name, Country, Sales
Pankaj, India, 100
Vikas, SL, 12
Raju, WJ, 10
Sujit, JH, 45
];

Output:

Name Country Sum(Sales) Rangesum
Pankaj India 100 100
Vikas SL 12 112
Raju WJ 10 122
Sujit JH 45 167

 

I am using Aggr(RangeSum(above(sum(Sales),0,RowNo())),Country,Name)

Labels (1)
1 Solution

Accepted Solutions
Digvijay_Singh

May be something like this - 

RangeSum(above(Total sum(Sales),0,RowNo(Total)))

Digvijay_Singh_0-1645846197098.png

 

View solution in original post

2 Replies
Digvijay_Singh

May be something like this - 

RangeSum(above(Total sum(Sales),0,RowNo(Total)))

Digvijay_Singh_0-1645846197098.png

 

passionate
Specialist
Specialist
Author

Thank you Digvijay!
Much appreciate your response