Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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

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