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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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