Calculate the Min of excluded dates

[adrien_marchadi]

Hello everyone,

I have been a Qlik Sense user for about 2 years for now. But I'm facing an issue I can't easily solve ...

I have a database with historical data, flagged by an extract date.

After applying some filters, I can find the max possible extract date.

What I want now is to find data related to the date directly after this max possible extract date.

With an image :

Note that "extract date+1" is not possible as I do not have data every single day (such as weekends) and because of active selection !

I tried mixing min-max and ALL-TOTAL, with no success:

Min(ALL Aggr(Only(If(Extract_date > Max(TOTAL Extract_date),Extract_date)),Extract_date))

Maybe the solution is using set analysis ...

Thank in advance for your help,

Adrien

[rachel_delany · Accepted solution]

Hi Adrien,

Would it work to set your max date as a variable and then use this as a reference in set analysis?

E.g.

maxDate = Max(Extract_date)

Min({1<Extract_date = {">=$(=maxDate)"}>} Extract_date)

[adrien_marchadi]

Thank you Rachel for this answer !

With slight modifications, it did the trick !