Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register 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
Partner

try

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

View solution in original post

4 Replies
dplr-rn
Partner
Partner

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
Partner

try

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

LordGrim
Contributor III
Contributor III
Author

 Yes and thankyou - worked fine. 😁