Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Change the expression to if(above(total Nom)<>Nom,Taille,rangesum(above(total MySum),Taille))
See attached qvw.
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...
Change the expression to if(above(total Nom)<>Nom,Taille,rangesum(above(total MySum),Taille))
Thanks so much !!! It's working !! OK, you're my hero now