topic Re: Previous period sum calculation in QlikView

Previous period sum calculation

MK97 — Thu, 07 Jul 2022 06:07:05 GMT

Hello,

I have problem trying to calculate previous period sum. Current period calculation is correct, but previous period calculation is always showing current period values:

Two variables that are used in calculations:

vMaxSelectedDate = Date(max(Date))

vMinSelectedDate = Date(min(Date))

Current period calculation:

sum({< Date={"<=$(vMaxSelectedDate)"}>} (AMOUNTMST)

Previous period calculation:

sum({< Date={"<=$(vMinSelectedDate-1)"}>} (AMOUNTMST)

Thank you in advance! 🙂

Re: Previous period sum calculation

BrunPierre — Fri, 08 Jul 2022 22:19:49 GMT

@MK97Try these expressions;

Current period calculation:

SUM({$<Date = {"$(=Date(Max(Date)))"}>}AMOUNTMST)

Previous period calculation:

SUM({$<Date={"=$(=AddYears(Max(Date),-1))"}>}AMOUNTMST)

Best regards

Re: Previous period sum calculation

BrunPierre — Thu, 25 Aug 2022 14:13:15 GMT

@MK97 Did it solve your problem? please mark accordingly.