Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to add the value in a coloumn to the above value in the coloumn

Hi,

i have a problem in displaying values.Could anyone suggest the expression for it.

I have values like

MONTH YEAR JAN 2015     FEB 2015       MAR 2015      APR 2015

Toyota               1234            4567            6789                9012

BMW                 2345            6789            9012                3456

aUDI                  3456            7890            1234                5678

The result i want to get is like

result                   3456           (3456+7890)       (3456+7890+1234)   (3456+7890+1234+5678).

Could anyone suggest the expression to get the result in the above way.

pls help me if you know this

regards

K.Anuraj

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to add the value in a coloumn to the above value in the coloumn

Hi,

Check try like this

=Rangesum(Sum(Sales), Above(Sum(Sales), 0, RowNo())

OR

=Rangesum(Sum(Sales), Before(Sum(Sales), 0, ColumnNo())


Hope this helps you.


Regards,

Jagan.

View solution in original post

5 Replies
Highlighted

Re: How to add the value in a coloumn to the above value in the coloumn

Hi,

try Full Accumulation option from straight table->Expression tab.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to add the value in a coloumn to the above value in the coloumn

Hi,

Check try like this

=Rangesum(Sum(Sales), Above(Sum(Sales), 0, RowNo())

OR

=Rangesum(Sum(Sales), Before(Sum(Sales), 0, ColumnNo())


Hope this helps you.


Regards,

Jagan.

View solution in original post

Highlighted
Master III
Master III

Re: How to add the value in a coloumn to the above value in the coloumn

tweaked a bit the exp suggested by jagan.

=Rangesum(Before(Sum(Data), 0, ColumnNo()))

Capture.JPG

Highlighted
Contributor III
Contributor III

Re: How to add the value in a coloumn to the above value in the coloumn

Thank you Jagan I am getting the values by writing that expression

Highlighted
Contributor III
Contributor III

Re: How to add the value in a coloumn to the above value in the coloumn

Thank you Digvijay Singh