Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

adrien_marchadi
New Contributor

Calculate the Min of excluded dates

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 :

Capture.JPG

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

1 Solution

Accepted Solutions
rachel_delany
Contributor

Re: Calculate the Min of excluded dates

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)

2 Replies
rachel_delany
Contributor

Re: Calculate the Min of excluded dates

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
New Contributor

Re: Calculate the Min of excluded dates

Thank you Rachel for this answer !

With slight modifications, it did the trick !

Community Browser