Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
i have the first table in qlikview, and i would like to get the second one.
¿can you help me?
Year_Month | Months | 0 | 1 | 2 |
201701 | 432 | 42 | 32 | |
201702 | 542 | 2 | - | |
201703 | 54 | - | - | |
Year_Month | Months | 0 | 1 | 2 |
201701 | 432 | 474 | 506 | |
201702 | 542 | 544 | - | |
201703 | 54 | - | - |
Hi Mark,
you can explore rangesum function in this scenario.
Regards,
Akshaya
Hi,
You can use rangesum function. See my attached .qvw (i made a new sample because i'am in Personnal edition right now)
Regards
it is writting the sum in places that before there wasn´t any data.
in places where now there is now data, it should be an acummulative sum and stop where there is now data.
May be this
If(Sum(V2) <> 0, RangeSum(Sum(V1), Sum(V2)), 0)
If(Sum(V3) <> 0, RangeSum(Sum(V1), Sum(V2), Sum(V3)), 0)