Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adrien_marchadi
Partner - Contributor II
Partner - Contributor II

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
Creator II
Creator II

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)

View solution in original post

2 Replies
rachel_delany
Creator II
Creator II

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
Partner - Contributor II
Partner - Contributor II
Author

Thank you Rachel for this answer !

With slight modifications, it did the trick !