Discussion Board for collaboration related to QlikView App Development.
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
Check try like this
=Rangesum(Sum(Sales), Above(Sum(Sales), 0, RowNo())
=Rangesum(Sum(Sales), Before(Sum(Sales), 0, ColumnNo())
Hope this helps you.
View solution in original post
try Full Accumulation option from straight table->Expression tab.
tweaked a bit the exp suggested by jagan.
=Rangesum(Before(Sum(Data), 0, ColumnNo()))
Thank you Jagan I am getting the values by writing that expression
Thank you Digvijay Singh