hii iam mahesh new to Qlikview family my question is

[Anonymous]

i had  data  like  this

month    values

jan           10

feb           20

mar          30

apr           10

may          -

jun           10

jul            -

my output should like this

month    values     sum(sales)

jan           10            10

feb           20             30

mar          30             60

apr           10              70

may          -                70

jun           10               80

jul            -                80

HOW IT IS POSSIBLE  IN EASY WAY? please help me

[ajsjoshua]

Hi,

In a chart go to expression and write Sum(Sales).

[ajsjoshua]

Add dimension as month in the chart.

Regards,

Joshua.

[Chanty4u]

Load [ Month], Exits, RangeSum(Exits,Peek(Cumulative_Exit)) as Cumulative_Exit;

LOAD * INLINE [

      Month, values

jan, 1

    feb, 2

................

    ];

[tresesco]

Straight table:

Dim: Month

Exp: =Rangesum(Above(Sum(Values),0, RowNo()))

[tamilarasu]

Hi Mahesh,

Go to expressions tab ,select the expression and check Full Accumulation.

[shaileshyerram]

This problem can be solved using Above() function.

in the attached example, I have used above(sum( Value ) expression to get the output.

Note: For the first value of the expression I am replacing ZERO with null value to get the correct sum.

[ramasaisaksoft]

Hi Mahesh,

Full Accumulation by default is unchecked so you need to select that option as shown above.