topic Re: next date using firstValue or fiesrSortedValue in QlikView

next date using firstValue or fiesrSortedValue

Wed, 16 Mar 2016 08:43:32 GMT

hello.

i have some actions that suposed to hapen in the future.

i need to get the first date fron all the future dates if there are bigger than today.

for example i have the dates 25-03-2016, 13-8-2016, 6-9-2016

and i need to get only 25-03-2016 as next date.

this is the code that i have:

load AccountId,

if(date(max(DriveDate_DateFormat))>Date(Now()),FirstSortedValue(date(max(DriveDate_DateFormat)),1)) as NextDonationDate,

Resident DonationEvents

Group By AccountId;

the error is " Nasted aggegation not allowed"

need your help please

Kushal_Chawda — Wed, 16 Mar 2016 09:01:21 GMT

what is the format of DriveDate_DateFormat?

Gysbert_Wassenaar — Wed, 16 Mar 2016 09:03:16 GMT

Try this:

Load

AccountId,

Min(DriveDate_DateFormat) as NextDonationDate,

Resident

DonationEvents

Where

DriveDate_DateFormat > Today()

Group By

AccountId

;

Wed, 16 Mar 2016 09:25:06 GMT

date

dd/mm/yyyy