topic Inter-Record Chart functions in QlikView

Inter-Record Chart functions

Fri, 13 May 2011 11:17:46 GMT

Hi, How would I calculate the Cumulative % column please? So that Cumulative % = (The previous row value, Column - 1) + (This row, Column - 1). Please see attached example. Thanks.

Inter-Record Chart functions

pat_agen — Fri, 13 May 2011 11:41:04 GMT

hi,

in a straight table copy and paste the expression from column "Cont%", rename it to "Cum%" and at the bottom of the expressions tab tick on the radio button "Full Accumulation".

Re: Inter-Record Chart functions

Fri, 13 May 2011 11:51:39 GMT

Thanks for your reply. I've done that but the Cum% is now equal to the Cont%. My expression for Cont% is:

(

(sum(if (InYear ([Sale Date], Today(), (zYearLast - Year(Today()))), [Sale Value]))) / sum(total(if (InYear ([Sale Date], Today(), (zYearLast - Year(Today()))), [Sale Value])))) * 100

Inter-Record Chart functions

pat_agen — Fri, 13 May 2011 12:06:06 GMT

hi,

my error. your expression is fine. my solution works if there is a single dimesion in the report.

You can see that in your second example where the accumulation works for the stores in the Inland area which are supermarkets.

Given your data this coudl be a possible workaround.

Working on the assumption that each store can only be in one area and of one type then instead of having these attributes as columns/dimensions put them in as expressions. for this use only(Area), only(TypeOfStore).

Your report will then have a single dimension and the accumulation should work for the whole dataset.

how is the weather down there?

Re: Inter-Record Chart functions

Fri, 13 May 2011 12:22:33 GMT

Thanks a lot, that did the trick! ... Sunny, but winter's on its way. So it's 24C instead of 30C. Cheers.

Inter-Record Chart functions

christian77 — Fri, 13 May 2011 12:54:00 GMT

Try these ones:

This one accumulates columns by row (or otherwise)

RangeSum(last($(vSaldo),1,(noofcolumns()-columnno()+1))

This one accumulates rows by column (or otherwise)

RangeSum(Above(Total $(vSaldo),0,rowno(Total)))