Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
SilvioQlik
Contributor
Contributor

Aggr(RangeSum(Above( .... Sorting Problem

Good Moning Comunity, I'm Silvio From Italy 

I have this Table :

SilvioQlik_0-1694180771105.png

I'm using the following formula to reach a progressive sum of QTA_PLAN for each KCODE ordered in ascending order with respect to the Data_MAD.  But as You can see on the Table the sorting is not correct.... I also tried to create a "chiave" with the concatenated information.. but it doesn't work.

Aggr(RangeSum(Above(sum([QTA_PLAN]), 0, RowNo())),KCODE,Chiave)

Can anyone kindly give me some help?

Thanks in advance

regards

Silvio

 

Labels (1)
1 Solution

Accepted Solutions
J_Lindberg
Support
Support

Hello @SilvioQlik , this forum is for the product "Qlik application automation" where we are able to help with questions related to this product. Please post this question in the forum related to the product you are using. Perhaps Qlik Sense: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Or QlikView: https://community.qlik.com/t5/QlikView/ct-p/qlikview

 

View solution in original post

1 Reply
J_Lindberg
Support
Support

Hello @SilvioQlik , this forum is for the product "Qlik application automation" where we are able to help with questions related to this product. Please post this question in the forum related to the product you are using. Perhaps Qlik Sense: https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense

Or QlikView: https://community.qlik.com/t5/QlikView/ct-p/qlikview