Running subtotal count expression help

Fri, 06 Nov 2009 23:15:53 GMT

Hello,

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?

Running subtotal count expression help

johnw — Sat, 07 Nov 2009 00:09:21 GMT

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:

rangesum(F1,above("Running Total"))

topic Running subtotal count expression help in QlikView

Running subtotal count expression help

Running subtotal count expression help