Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2016-07-01 04:19 AM

Accumalative Value

Hi All,

I have an issue, I have a straight table with 2 dimensions, DATE and PERIOD, there is a calculation on this table, and then I was to accumulate the calculation. the "full accumulation" option on the expressions tab is not working and all the calcs that I am trying either over add or simply bring back the line's result...please assist.

Current Formulae:

=Imbalance+RangeSum(above([Settlement Total]-[Stratus Total],0,RowNo()))

Thanks

533 Views
0 Likes
5 Replies
MK_QSL
MVP
MVP
‎2016-07-01 04:25 AM

Do you want to Accumulate with both Dimensions?

Can you provide sample data?

381 Views
sunny_talwar
MVP
MVP
‎2016-07-01 04:33 AM

What is Imbalance here? That doesn't need to be fully accumulated?

381 Views
0 Likes
Not applicable
‎2016-07-01 04:55 AM
Author

In response to MK_QSL

Hi there,

Yes I would assume that I would.

Regards

381 Views
0 Likes
Not applicable
‎2016-07-01 04:55 AM
Author

In response to sunny_talwar

Imbalance is the calculated feild

381 Views
0 Likes
Anonymous
Not applicable
‎2016-07-01 06:41 AM
Author

Hi,

Can u provide sample data or qvw?

381 Views
0 Likes