You are using multiple dimensions ( I assume they are named liked MONTH and COHORTE), so you might need to additionally use advanced aggregation to get your column segments for the accumulation using above() right, maybe along these lines:
=aggr( rangesum(above( sum(REVENUE), 0, rowno() )), COHORTE, MONTH)
edit: One more thing, if you are using the advanced aggregation (aggr() function), you'll need to ensure, that MONTH field values load order is chronological ascending, e.g. by loading a master calendar first. The aggr() function's dimension values will always be ordered in load order (not regarding any order you may define for the chart).
I'm trying with RangeSum(Above(Sum(REVENUE),0,RowNo())). The problem is that this fonction depend on the sort order, we can figure it in these two tables :
The first one is obtained by changing the sort order of the columns and the result is OK.
The second is the original table obtained from the chart. The problem is that I cannot change the sort order of columns in the chart. So I need an expression where the rowno is obtained from the following sort order : COHORT, MONTH
This is with regard to the Custom OnClearAll document even in Qlikview athttp://qlikshare.com/856.
I have tried the similar function in my file but I am not able to implement that. The function is exactly written the same way as you have been. It works fine till the concat level but when I go for the the $ expansion, it cripples.
Could you provide me with some reasoning for this. Attached is qvw file explaining the situation in the sky blue text box. The Schema is pretty simple with just two fields over there.
The function I am using is
=$(=concat(DISTINCT ‘GetSelectedCount(‘& $Field & ‘)’, ‘ + ‘))
Test_File.qvw 176.2 K
Sorry for the delayed response. You need to use the square brackets.
=$(=concat(DISTINCT ‘GetSelectedCount([‘& $Field & ‘])’, ‘ + ‘))
I hope this helps! Also, if you are using "Always one value selected" then you need to tweak the logic in the expression. It works great for me.