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.
