Nested aggregation not allowed

DestinedTale — Sat, 16 Nov 2024 04:42:07 GMT

Hi,

I have an issue with adding $(DiffDate) to the expression in load script.

set DiffDateformula = num(DayStart(Date#(left([@9], 8), 'YYYYMMDD'))) - num(DayStart(Date#(left([@5], 8), 'YYYYMMDD')));
let DiffDate = $(DiffDateformula) + 1;

if MonthStart($(timeStampDate)) = MonthStart($(today)) then
whichDay = $(today);
else
whichDay = num(DayStart(MonthEnd($(timeStampDate))));
endif

if (max($(whichDay)- num(DayStart(Date#(left([Due Date], 8), 'YYYYMMDD') - $(DiffDate)))) < 0, 0, max($(whichDay)- num(DayStart(Date#(left([Due Date], 8), 'YYYYMMDD') - $(DiffDate)))))) as [Aging Days]

Regards,

Re: Nested aggregation not allowed

uacg0009 — Tue, 22 Jan 2019 09:42:27 GMT

Hi,
Could you please share a small sample data, so I can try to find the reason,
I think maybe the variable can't get the right value, but I need a sample to prove it.
Aiolos Zhao

topic Re: Nested aggregation not allowed in QlikView

Nested aggregation not allowed

Re: Nested aggregation not allowed