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: 
LordGrim
Contributor III
Contributor III

Next meeting date (after today) as a KPI

I have a meeting_date field which is includes all post and future meeting dates. I want to show the 'next' meeting date after today?

I have a Max(meeting_date) which shows me the last meeting date booked but I know want to bring in a min after today()? Any ideas? Its DD/MM/YYY format for the UK.

Thanks

 

 

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

try

min({<meeting_date={">$(=today())"}>}meeting_date)

View solution in original post

4 Replies
dplr-rn
Partner - Master III
Partner - Master III

use set analysis something like below

count({<meeting_date={">$(=today())"}>}meetingid)

 

LordGrim
Contributor III
Contributor III
Author

Thanks ... I just want to display the 'Next date', not sure I made that clear. 

dplr-rn
Partner - Master III
Partner - Master III

try

min({<meeting_date={">$(=today())"}>}meeting_date)

LordGrim
Contributor III
Contributor III
Author

 Yes and thankyou - worked fine. 😁