Data accumulate

[#1]

Hello,

I have a problem need you help.

I have a table contain 2 columns Date and Amount as below. I need a line chart to show the accumulate amount by each day follow the rule. Any solution for that in Qlikview will be appreciated.

[parpatra]

You can use the option "Full acumulation" in expression tab of the chart properties.

[#3]

Hi...

Try using the full accumulation in the expression tabs for the amounts field. I think that should solve your problem.

- Kumar

[#4]

Thanks for the help.

It works only if there is no date range selected. If I select date from 11/09/2010 to 11/01/2010, it does not work.

[parpatra]

You can try set analysis...

=sum({<Year={<$(v_Curryear)>}>}Amount (You can modify this as per yoyur requirement.

Now if you use this expression with full accumulation, when you select a particular range of date it will show the graph for the range of date.

ex If you select month Jan and Feb together it will show you result for Jan and Feb with Feb value as Jan+Feb.

[johnw]

You can generate an AsOf table:

AsOfDate, Type, Date
10/29/2010, Amount, 10/29/2010
10/30/2010, Amount, 10/30/2010
10/31/2010, Amount, 10/31/2010
etc.
10/29/2010, Sum, 10/29/2010
10/30/2010, Sum, 10/29/2010
10/30/2010, Sum, 10/30/2010
10/31/2010, Sum, 10/29/2010
10/31/2010, Sum, 10/30/2010
10/31/2010, Sum, 10/31/2010
etc.

Pivot table:

dimension 1 (left) = AsOfDate
dimension 2 (top) = Type
expression = sum(Amount)

Straight table:

dimension = AsOfDate
expression 1 = sum({<Type={'Amount'}>} Amount)
expression 2 = sum({<Type={'Sum'}>} Amount)