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

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: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
Labels
1,111 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?

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

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

959 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

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

In response to sunny_talwar

Imbalance is the calculated feild

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

Hi,

Can u provide sample data or qvw?

959 Views
0 Likes