topic Re: Full Accumulation with multiple dimensions. in QlikView

Full Accumulation with multiple dimensions.

Mon, 09 Feb 2015 20:50:35 GMT

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??

Re: Full Accumulation with multiple dimensions.

sunny_talwar — Mon, 09 Feb 2015 21:08:40 GMT

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,

Re: Full Accumulation with multiple dimensions.

richard_chilvers — Wed, 10 Jun 2015 14:25:39 GMT

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.