Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
katetsan
Creator
Creator

Cumulative Sum

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.

1 Reply
Sergey_Shuklin
Specialist
Specialist

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.

c_sum.png