topic Data accumulate in QlikView

Data accumulate

Tue, 09 Nov 2010 20:49:08 GMT

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.

Data accumulate

parpatra — Tue, 09 Nov 2010 21:22:01 GMT

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

Data accumulate

Tue, 09 Nov 2010 21:27:03 GMT

Hi...

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

- Kumar

Data accumulate

Tue, 09 Nov 2010 21:53:41 GMT

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.

Data accumulate

parpatra — Tue, 09 Nov 2010 22:02:35 GMT

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.

Data accumulate

johnw — Tue, 09 Nov 2010 22:04:36 GMT

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)