Startvalue and cumulative

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

Hopefully someone can help with the challenge I'm facing.

I created a dynamic pivot table. This pivot table exists of two dimension. A brand or other dimension related to the brand and a time dimension being a year, month, week oor day. These dimensions can be turned on or of by a listbox with the dimensions in it.

the data can look like this:

month 1,2 and 3 also has got amounts in it!

Brand	month	start	expression1	expression2	total of start + expr1 + expr2
brand1	4	sum of previous month(s)	sum of amount1 this month	sum of amount2 this month	total of previous 3 columns
	5	previous total at the right	sum of amount1 this month	sum of amount2 this month	total of previous 3 columns
	6	previous total at right side	sum of amount1 this month	sum of amount2 this month	total of previous 3 columns

the expression used for start is:

if (

RowNo() = 1,

sum(aggr(sum({$<TransactionDay = {"<$(vStartDate)"}>} total <$(vDimension)> Amount),$(vDimension) )),

above([Floatwaarde end])

)

vDimension is declared in the Variable Overview:

=subfield(GetFieldSelections( Listbox with dimensions),',',1)

However: if there is no data in month 5 QlikView cannot continue aggregating the first column().

Can anyone please help finding a solution for my expression. Would be great.

Thanks in advance,

topic Startvalue and cumulative in QlikView

Startvalue and cumulative