Discussion Board for collaboration related to QlikView App Development.
I explain what I would like to achieve in Qlikview, I have a below data,
I would like to calculate the Qty and show it as below
Can anyone please let me know, how can I achieve the expected Qty using set analysis or other expressions.
May be try this
RangeSum(Above(TOTAL Sum(Qty), 1, RowNo(TOTAL)))
View solution in original post
I've been looking through your answers to Qlik Community Questions on Cumulative Sum.
Would you be able to help with this one?
We're having troubles trying to get the cumulative percentage in a pivot table? Please see this thread:
Calculating Cumulative Percentage of Total by Column (Pivot Table)
is it possible to calculate the cumulative sum for a further grouping-dimension.
Let say i have a field with two categories and i want to display the cumulative qty in a line chart with two lines
How do i adjust the expression to consider the grouping dimension?