topic Calculate the Min of excluded dates in Management & Governance

Calculate the Min of excluded dates

adrien_marchadi — Mon, 09 Apr 2018 15:33:15 GMT

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 — Tue, 10 Apr 2018 02:30:32 GMT

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 — Thu, 12 Apr 2018 15:11:29 GMT

Thank you Rachel for this answer !

With slight modifications, it did the trick !