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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sguerin
Partner - Contributor II
Partner - Contributor II

Accumulated against sorting data in straight table

Hi everyboy,

I am quite surprised to have so many problemes on a very simple looking case.

I've got two dimension : Dim1, Dim2

I've got just a data : Volume

I just want, in a straight table, have Dim1,Dim2 dimension with Sum(Volume) as expression.

I want to have a decreasing sort on Sum(Volume) without considering the dimensions.

So far, so good.

Then I want to add an expression that calculate the proportion of  Sum(Volume) against the total ==> Sum(Volume)/Sum(total Volume) in %

So far, so good again.

But when I want a cumulative vision of my proportion of Sum(Volume) against the total, I've got more difficulties !

After lots of try, I've found an expression that make me well my cumulative vision () , but I lost the decreasing sort on Sum(Volume) :

=rangesum(above(total (Sum(Volume)/Sum(total Volume)),0, rowno(total)))

I've read that RangeSum function, by default, takes the 'Load Order'.

http://community.qlik.com/message/360555

I've got no idea left ;-(

I've attached a sample with what I expected.

Thanks a lot by advance for your feedback.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add a calculated dimension to sort on and then hide it. See attached example.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add a calculated dimension to sort on and then hide it. See attached example.


talk is cheap, supply exceeds demand
sguerin
Partner - Contributor II
Partner - Contributor II
Author

Great ! Thanks a lot Gysbert.

I think is one among many solution.

I've found one a bit more different.

I've add a calculated dimension that is just the concatenation of Dim1+Dim2

An then I've set a decreasing sort order on each dimension with the expression  "Sum(Volume)".