topic column to column summation in QlikView

column to column summation

Tue, 28 Aug 2012 06:21:42 GMT

Hi Friends,

I have set of values calculated as shown below...

Dimension	A	B	C
Bat	5	3	7
Ball	10	7	2
Stumps	3	2	4
Gloves	2	5	3

From the above, i need to get the below result by summation of each column to column.. Kindly help

Dimension	A	A+B	A+B+C
Bat	5	5 + 3 = 8	5 + 3 + 7= 15
Ball	10	10 + 7 = 17	10 + 7 + 2 = 19
Stumps	3	3 + 2 = 5	3 + 2 + 4 = 9
Gloves	2	2 + 5 = 7	2 + 5 + 3 = 10

Thanks in advance...

Ram

sivarajs — Tue, 28 Aug 2012 06:53:13 GMT

Check the attached file

Tue, 28 Aug 2012 07:10:30 GMT

thanks for reply sivaraj but actually the value A,B and C is also dynamic ..

i have to calculate the summation of BAT,BOWL induvidually for (say..Customer) A,B and C

and also have to show the summation of previouly calculated value with current value.

Tat;s the complexity involved in this case..

How can we rectify this.plz share if u hav idea..

Tue, 28 Aug 2012 09:01:39 GMT

Once again, thanks for yr reply .

But those value A, B,C is dynamic value.It might have D for some cases and even E,F for some other..

That's depend on selection.

so, i cant use columns as suggested.

Kindly advice , how can we handle the above case..

Tue, 28 Aug 2012 09:49:13 GMT

sorry, its not works for my case.... Checked yr last sample file.

In that label A , B and C has no links for selection.

Lets group it as Customer where values of customer be A,B and C.

Have to calculate the summation of items based on the customer selected.

For example, if user choosen A and B alone, hav to show the details on A and B alone.I cant hardcore sum(A+B+C) in expression. its an dynamic value.

thanks for yr prompt reply..

Tue, 28 Aug 2012 11:07:55 GMT

Hi friend,

I got the desired answer by using the below function :

rangesum(sum(value),Before(EXpressionLabel))

Thanks for replies.....