I have a table with data and I am trying to get a running subtotal of the count in column F1 and use that as the denominator. The problem I have is if, I use the TOTAL function is gives me the Total value (205) as the denominator for all rows.
Here is the table: (F1 Expected Subtotal is what I am looking for)
Date
F1
F1 Expected Subtotal
F2
Date1
29
29
4
Date2
23
52
8
Date3
17
69
9
Date4
15
84
13
Date5
13
97
20
Date6
31
128
21
Date7
27
154
26
Date8
16
168
29
Date9
20
188
32
Date10
15
203
36
Date11
6
205
36
Here is the formula that I am using: (Date is the dimension)
1. Sum(F2)/Sum(F1) - this formula only calculates the percentage for each month.
2. Sum(F2/Sum(Total F1) - this is the formula that give me 205 as the demoninator for all Dates.
Is there another expression or something I am missing?
The sum(total F1) is telling QlikView that you want to ignore the dimension (Date) and just return the total of the entire column. An easy way to get a running total is to just turn on full accumulation. However, I don't think that will let you use the running total in another expression. To get a running total that you can use in another expression, I think you need to add a Running Total column with this expression:
