topic Re: if condition for sum rows in QlikView

if condition for sum rows

chrissyp — Thu, 30 Aug 2018 08:31:19 GMT

Hello everyone,

i try to sum rows in a pivot table with if condition.

MY data look like

Zeilennr Konto Betrag

1 4677 20

2 4711 50

3 - (20+50)

4 4855 80

5 - (20+50+80)

so i want something like if(zeilennr=3, sum (betrag of zeilennr 1 and zeilennr 2)

and for zeilennr 5 if( zeilennr=5, sum (betrag of zeilennr 1 and zeilennr 2 and zeilennr 4)

can anybody help

thx

chrissy

ogautier62 — Thu, 30 Aug 2018 09:02:17 GMT

Hi,

so you want a cumulative sum do you ?

you could look at functions above() or before() with rangesum

regards

chrissyp — Thu, 30 Aug 2018 09:18:17 GMT

I just want a cumulative sum for zeilennr 3 and 5 zeilennr 1, 2 and 4 just should be the normal sum