Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

value in Full Accumulation

hi ,

i have one issue,

i have one dimension (values q1,q2,q3,q4)

but i want write expression like (q1,q1+q2,q1+q2+q3,q1+q2+q3+q4)values

how to write expression for that issue and also

am attached qvw

please help me, thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

There are two options

1) Use this expression

=RangeSum(Above(Sum({<CFWB_Display_Year=,dtdim_fydispname=,Col_display_year=,BudgetRev_st_probability={'100'} >}BudgetRevRevForecasted)/Value, 0, RowNo()))

2) Check 'Full Accumulation' on the expressions's tab

Capture.PNG

View solution in original post

2 Replies
Anil_Babu_Samineni

I don''t have license, Can you share the sample data which demonstrates the o/p

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

There are two options

1) Use this expression

=RangeSum(Above(Sum({<CFWB_Display_Year=,dtdim_fydispname=,Col_display_year=,BudgetRev_st_probability={'100'} >}BudgetRevRevForecasted)/Value, 0, RowNo()))

2) Check 'Full Accumulation' on the expressions's tab

Capture.PNG