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

Labels (4)
0 Replies