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)
@sunny_talwar can you please assist what I am missing

Labels (4)
0 Replies