topic bar chart, accumulate the last month in QlikView

bar chart, accumulate the last month

dcd123456 — Fri, 04 Jul 2014 12:24:33 GMT

hello

i have a bar chart that show a count by month, the last month is the actual month.

is there anyway to do that the last bar (the actual month) could accumulate the value of the last month and current month.

for example in this table

i need that the last bar that represent July 2014 accumulate the value of jun 2014 and jul 2014 and then show value 2 instead of 1.

i have attach an example.

thanks in advance for your help

regards

tresB — Fri, 04 Jul 2014 12:32:11 GMT

=If(Rowno()<>NoOfRows(), count( DISTINCT Valor), RangeSum( count( DISTINCT Valor),Above(count( DISTINCT Valor))))

Or a bit simpler:

=If(Rowno()<>NoOfRows(), count( DISTINCT Valor), RangeSum( Above(count( DISTINCT Valor),0,2)))

dcd123456 — Sat, 05 Jul 2014 06:59:57 GMT

Thanks very much for the answer, it works right

regards

dcd