topic Accumulating line by line in QlikView

Accumulating line by line

Thu, 05 Dec 2013 02:49:30 GMT

Hello people,

I'm adding this worksheet to better explain my problem.

in column H i have a cumulative value. which is actually the value of the cell above it but the same result.

Tried the RANGESUM.

Thu, 05 Dec 2013 03:14:07 GMT

hi,

get accumulated with this expression.

RangeSum (Above (Total Sum (QTD_EMBALAGEM), 0, Rowno (Total)))

only after I put this espresão can not sort by the expression to be in column 1.

Thu, 05 Dec 2013 04:13:26 GMT

try this

expression1--- QTD_EMBALAGEM

Expression2----RangeSum(Above(sum(QTD_EMBALAGEM),0, rowno()))

angelaecheverri — Thu, 05 Dec 2013 12:41:28 GMT

sum(Total qtd) = sums all the records for qtd taking care of your selections

sum(all qtd) = sums all the records of your data... its doensnt take care of your selections...

Thu, 05 Dec 2013 12:48:43 GMT

Hi Angela,

then how is my these two expressions: Sum (QTD_EMBALAGEM) and RangeSum (Above (sum (QTD_EMBALAGEM), 0, Rowno (TOTAL)))?

I have to sort from highest to lowest the Sum (QTD_EMBALAGEM) expression.

and I can only sort by dimenssões.

Thu, 05 Dec 2013 13:42:04 GMT

Hello people,

to make it easier I made this example.

angelaecheverri — Thu, 05 Dec 2013 16:23:43 GMT

I dont get what are you saying...

you can sort by dimension and by expresions....

if you want to sort by an exprssion...

just go to sort and do it by exprresion...

Thu, 05 Dec 2013 19:16:11 GMT

do not know how I did not think of that before.

Thank you Angela

angelaecheverri — Thu, 05 Dec 2013 23:48:24 GMT

Your welcome