topic Re: Cumulative Sum order by dimension in QlikView

Cumulative Sum order by dimension

louisernould — Fri, 17 Oct 2014 07:42:42 GMT

Hi the Qlik Community !

I have a small problem and I think it's about synthax. I have a table, and I want the cumulative sum of a dimension.

On the table above, I have [Nom], and [Taille], and I want the cumulative sum of the [Taille] but order by the dimension [Nom].

I already try 2 differents things, but It's not what I want...

Nom	Taille	test	RangeSum(Above(Sum(Taille),0, RowNo(total)),Nom)	If(Dimensionality()=1 , Aggr(RangeSum(Above(Sum([Taille]),0,RowNo(TOTAL))),Nom) , IF(Dimensionality()=0 , Sum(Taille) ,RangeSum(Above(Total Sum([Taille]),0,RowNo(TOTAL)))))	WHAT I WANT
A	6	non	6	6	6
A	10	oui	10	16	16
A	11	non	11	27	27
B	3	non	3	30	3
B	4	oui	4	34	4

If someone has the solution, he will be my hero !

Thanks

Louis

Re: Cumulative Sum order by dimension

Gysbert_Wassenaar — Fri, 17 Oct 2014 10:03:29 GMT

See attached qvw.

Re: Cumulative Sum order by dimension

louisernould — Fri, 17 Oct 2014 12:30:31 GMT

Thank Gysbert,

actually, it's not working a 100%. With your solution, I want to keep the 'test' Dimension, and when i keep it, my culumative sum bugs and doesn't work...

Re: Cumulative Sum order by dimension

Gysbert_Wassenaar — Fri, 17 Oct 2014 12:34:10 GMT

Change the expression to if(above(total Nom)<>Nom,Taille,rangesum(above(total MySum),Taille))

Re: Cumulative Sum order by dimension

louisernould — Fri, 17 Oct 2014 12:42:48 GMT

Thanks so much !!! It's working !! OK, you're my hero now