Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator III

Add below Value

Hi all,

Sorry for asking silly question but i  am not able to get the anwer

Data look Like this i have 2 fields Date  and Value and 3rd column shows the the required ouptput.

DateValueRequired Output
01-01-2013100

100

02-01-2013200300
03-01-2013300600
04-01-20134001000
05-01-20135001500
06-01-20136002100

Thanks

rohit

6 Replies
rohit214
Creator III
Creator III
Author

any one.....

nagaiank
Specialist III
Specialist III

In straight table chart, define Date as dimension and Sum(Value) as expression. Check Full Accu,u;ation in the Accumulation box in the properties window Expressions tab to get cumulative (required) value.

rohit214
Creator III
Creator III
Author

hi Sir,

thanks for your answer,

I want that in a field in back end or using expression in front end.

thanks

rohit

Not applicable

Try the below expression..

=Rangesum(above(sum(Value),0,rowno()))

jagan
Luminary Alumni
Luminary Alumni

Hi Rohit,

If you are try this in script then use below script

Test:

LOAD *,

If(RowNo() = 1, Sales, Peek('AccumulatedSales') + Sales) AS AccumulatedSales

INLINE [ 

    Year, Sales

    2008, 1000

    2009, 2000

    2010, 3000

    2011, 2000

    2012, 3000

    2013, 4000

];

Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi Rohit,

PFA file for solution.

Regards,

Jagan.