Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Full Accumulation with multiple dimensions.

Hi,

I am using below expression to calculate the accumulated returns with date and symbols as dimensions for a line chart. This works fine if I select a one symbol.

(rangesum(above(total sum(returns),0,RowNo(TOTAL))))

But I want to be able to select multiple symbols at the same time, plot accumulated returns for each symbol in the line chart.

I know I can simple plot the returns in the line chart by checking full accumulation, But I want to do that in an expression.

Could any one please help me with my problem??

2 Replies
sunny_talwar

Dummy data would be useful to play around with. Otherwise I can only speculate the idea of using a aggregate function. May or may not work.

Best,

S

richard_chilvers
Specialist
Specialist

Hi

I have noticed similar issues. Simply put, it looks as if the accumulation only occurs at the lowest level of dimension. But I haven't yet found that explained anywhere.