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

How to calculate min date of a list but higher than today?

Hi Community,

I need to create a 'Days left' object. We have a list of deadlines and would like to show the difference between the min date of the list and today. However min date of the list should always be greater than today, so in this case 2018-05-29 instead of 2018-05-26.

Today is: 2018-05-27.

Example table:

LOAD * INLINE [

    Date1

    2018-05-26

    2018-05-29

    2018-06-29

];

Ideal result should be 2018-05-29 - 2018-05-27 = 2 days left.


Thanks in advance!!

1 Solution

Accepted Solutions
sunny_talwar

May be this

Min({<Date1 = {"$(='>=' & Date(Today(), 'YYYY-MM-DD'))"}>} Date1) - Today()


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

May be this

Min({<Date1 = {"$(='>=' & Date(Today(), 'YYYY-MM-DD'))"}>} Date1) - Today()


Capture.PNG

mrichman
Creator II
Creator II
Author

Thanks!