accumulation in graph

Wed, 19 Jun 2013 14:52:04 GMT

Hello,

I'm trying to create a graph that uses another expression. This works fine in the straight table and provides me with the right data, however when converting this to a graph and not wanting to see the expression I required to get the index number I run into trouble.

I accumulate the periodic turnover by week or period. and then divide it by the acumulated turnover of the previous year.

This creates an index development of 2 seperate years

((sum({<KA_SUJaar={$(=year(today()))}, table_code = {2} >}omzet)) + if(rowno()=1,0,above([Cum huidig jaar])))
/
((sum({<KA_SUJaar={$(=year(today())-1)}, table_code = {2} >}omzet)) + if(rowno()=1,0,above([Cum huidig jaar -1])))
*100

Hope anyone has a solution for me. We are using an extensive database therefore creating datapoints in the script is not preferred ( or even not an option)

Thanks for your help!

topic accumulation in graph in QlikView

accumulation in graph