Cumulative Sum

katetsan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Communities,

I was trying to create a bar chart with cumulative value by date and currency type, but the result doesn't work well.

Formula is as below:

Pick(match(Valuelist('TWD','RMB','USD','JPY','EUR'),'TWD','RMB','USD','JPY','EUR'),

Rangesum( above(Sum({<Currency={'TWD'}>}Amt_test), 0, RowNo())),

Rangesum( above(Sum({<Currency={'RMB'}>}Amt_test), 0, RowNo())),

Rangesum( above(Sum({<Currency={'USD'}>}Amt_test), 0, RowNo())),

Rangesum( above(Sum({<Currency={'JPY'}>}Amt_test), 0, RowNo())),

Rangesum( above(Sum({<Currency={'EUR'}>}Amt_test), 0, RowNo()))

)

Dimensions:

1. Date

2. ValueList('TWD','RMB','USD','JPY','EUR')

Is there anyone could give some advice?

Thanks in advanced.

Re: Cumulative Sum

Sergey_Shuklin — Fri, 07 Sep 2018 05:29:35 GMT

Hello, Kate!

If you don't have zero-rows of current currency and date, even ValueList() won't help. Try to add empty rows in the script and then use Full Accumulation with unchecked Suppress Zero Values.

topic Cumulative Sum in QlikView

Cumulative Sum

Re: Cumulative Sum