2 Replies Latest reply: Apr 12, 2018 11:11 AM by Adrien Marchadier

Calculate the Min of excluded dates

Adrien Marchadier Apr 9, 2018 11:33 AM

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

Re: Calculate the Min of excluded dates

Rachel Delany Apr 9, 2018 10:30 PM (in response to Adrien Marchadier)

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)
Like Show 0 Likes (0)

Actions
- Re: Calculate the Min of excluded dates
  
  Adrien Marchadier Apr 12, 2018 11:11 AM (in response to Rachel Delany)
  
  Thank you Rachel for this answer !
  With slight modifications, it did the trick !
  
  Like Show 1 Like (1)
  
  Actions